Tuesday, October 04, 2005

[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.
 

No comments: