Probably, but a couple of examples of your date-dependent formulas would sure
help.

Also, look at the NOW() function in Excel. That may help you with this
problem. You can do math with it that will give elapsed time between dates,
as NOW()-30 for a date 30 days previous to the current date.


"Dominic" wrote:

Want the excel file to open so the date-dependent formulas refresh to the new
month. Then save the file. Can this be done?