Subtract Years and show date

AppSheet AppSheet Q&A
1

Hi

Im wanting to use a formula to subtract X amount of years from todays date and show the date with day, month and year.
Does anyone have a clever solution for this problem?

Best regards

2

Hi @RybJ

According to this:

https://help.appsheet.com/en/articles/2430932-eomonth

I would suggest:

EOMONTH(TODAY(), -1 +[numbersOfYearsForward]*12) + DAY(TODAY()) 
or
EOMONTH(TODAY(), -1 -[numbersOfYearsBackward]*12) + DAY(TODAY())

This will return a date.

You can enclose it with

TEXT([DateResult],"dddd mm yyyy")

if necessary

3 Likes
3

Hi!
Thanks, that worked wonders!

2 Likes