Put this formula this in any cell (except A1):
=DATE(YEAR(A1), MONTH(A1), DAY(A1)-35)
Assumes your date is in Cell A1
or
=DATE(YEAR(A1), MONTH(A1), DAY(A1)-(A2))
Where your date is in Cell A1 and number of days is in Cell A2
This is where I keep the answers I find that worked...
No comments:
Post a Comment