Monday, September 12, 2011

Excel - Subtract a number of days from a date

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

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...