Date Calculation

[RBburn]

Hi All,

I have a formula that calculates the percentage of time elapsed after 90 days and 365 days, but when I update the file, the percentage keeps changing and updating. The formula calculates the time elapsed based off of "today's" date, but need it to calculate based off of a fixed date, which I will input in a different cell. Any idea what formula to use to accomplish this or what changes I need to make? Below is the formula I am using. Cell E4 below is the date it is calculating off of. Thanks for your help in advance.

=IFERROR(TODAY()-E4,0)/90
=IFERROR(TODAY()-E4,0)/365

-Ryan

[RBburn]

I just decided to go with a simpler formula instead of the IF formula above. I just added in a fixed date and then subtracted the two dates and divided by 90 and 365. That way I don't have to worry about the date updating every time I refresh the page or open it.

[FDibbins]

Just to answer your 1st question - TODAY will always show - well, today's date. if you save the file today, with today's date showing, when you open it tomorrow, it will show tomorrow's date. The only way to get a fixed date is to enter it