After the useful ‘current date’ and ‘current time’ formulas in our Hints & Tips a few weeks ago, we thought a few more would be helpful.
Below you will find some examples of how you can use a number of different formulas to capture accurate data on your forms…
The current date
=today() + 30
The current date plus 30 days
=today() + 90
The current date plus 90 days
=today() – 1
The current date minus 1 day (yesterday) Insert any number into your formula for the number of days you require to be calculated.