davidalmbe
New Member
- Joined
- Dec 1, 2002
- Messages
- 2
I have set up a spreadsheet to track production. Once the fields all hit 100% I have a formula that will return a date that every step was completed. I have set it up in such a way that once the totals hit 100% it returns a date complete.
The problem I have is I use the "today" or "now" return and it retunrs the date all right. But the date is a volatile date. Every time I open the spreadsheet it changes the date to todays date.
I need for the date to stay static once it is returned. Is there a command I can put in the "if" formula to return the date and make it static.
Thanks,
Dave
The problem I have is I use the "today" or "now" return and it retunrs the date all right. But the date is a volatile date. Every time I open the spreadsheet it changes the date to todays date.
I need for the date to stay static once it is returned. Is there a command I can put in the "if" formula to return the date and make it static.
Thanks,
Dave