| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
formula IF returning current date
I have a formula using IF ie if blank leave blank, if not return current date using NOW(). However, this date is changing daily. Is there something I'm missing where I can ask within the formula to return the date of change and retain that date (instead of it changing daily per the system)?
cheers just referenced the McGimpsey web page suggested by PEO Sjoblom mid January... thanks. Last edited by diane : March 10th 05 at 04:33 AM |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with VBA returning the contents of a long formula. | Excel Discussion (Misc queries) | |||
| Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
| Lock in current date | Excel Discussion (Misc queries) | |||
| Date Formula | Excel Discussion (Misc queries) | |||
| Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions | |||
Threaded Mode
