Forum Discussion

ElaineJoughin's avatar
ElaineJoughin
Copper Contributor
Mar 18, 2022

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 calculate a difference in months. The value calculated needs to be retained.

 I am successful if I enter the date manually without using the TODAY fx.

Is there a way that I can automate data entry using TODAY?

Thanks

Excel on Mac
Formulas and Functions

1 Reply

Sort By
  • Starrysky1988's avatar
    Starrysky1988
    Iron Contributor
    Mar 19, 2022
    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.

Resources