Subtract Years and show date

[RybJ]

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 

[Aurelien · Accepted solution]

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

[RybJ]

Hi! 
Thanks, that worked wonders!