Forum Discussion
Using TODAY fx with DATEDIF
I am creating a spreadsheet and would like to use the TODAY function to allow the user for automatic entry and then keep that date for future reference. Then I would like to use that date to calcula...
It is impossible to retain the value you calculated using today function as it is a volatile function and it will keep updating whenever you open the excel workbook or you do any changes in that workbook. You may consider to use VB code instead.