#9 Date function/ Today Funcation

[Sachin M]

Greate app, but no data functions!!

=today()
=now()
=day()
=dateif()
=dateadd()

atleast today() date is must to calculate say expiry

last dental visit : 01/Oct/2010
Next visit : 6 mon
To calculate pending days : (01/Oct/2010) + (6*30=180) - today()

Please do needful.

[Michael Zemljanukha]

Yes, sounds reasonable. But there are some complications - in Excel today() is a 'volatile' function, which is recalculated on every cell change: http://www.decisionmodels.com/calcsecretsi.htm
MC2 doesn't support such workflow, it is not just adding a new function. As for dateif() and dateadd() - you can do it, regular math functions are applicable for date type. So you can compare dates as numbers, and add days, etc

[Sachin M]

Thanks,

if recalculation done once when sheet open then this will avoid every cell change overload.

just idea, but truly 1 date volatile function will add more usefulness for mobile app to have.

Regards,