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
=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
0 comments:
Post a Comment