• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 15. Formatting and Calculating D... > Calculating with Date and Time

Calculating with Date and Time

Because Excel records dates as serial date values, you can use dates in formulas and functions as you would any other value. Suppose you want to find the date that falls exactly 200 days after July 4, 2004. If cell A1 contains the entry 7/4/04, you can use the following formula to compute the date 200 days later, which is 1/20/05 (or 38,372): =A1+200.

As another example, suppose you want to find the number of weeks between October 31, 2003, and May 13, 2004. Use the formula =((“5/13/04”)-(“10/31/03”))/7, which returns approximately 27.9 weeks.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint