[TIPS] - Excel tip - working with dates

Here's a tip for those of you who work in Excel and who often need to work with dates.

 

If cell A1= 10/25/05 , then A1-15 = 10/10/05, and A1-30 = 9/25/05 and A1+3=10/28/05

 

Meaning - you can add and subtract with dates just like numbers.