Thread: 360Days Formula
View Single Post
  #2   Report Post  
Dave O
 
Posts: n/a
Default 360Days Formula

Microsoft uses a scheme called "Serial dates" to keep track of dates.
If you enter information in Excel-approved date format, you can
calculate the number of days between two dates as simply as =B1-A1
where A1 and B1 are dates. Do a search on time and date functions in
Help to find out how extensively this has been covered.