Thread: how do you
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default how do you

True, but =DATEDIF(A1,B1,"d") should be the same as the rather simpler
formula =B1-A1. The main problem with the latter is remembering to set the
format of the result cell to General or Number, not to Date.
--
David Biddulph

"Nate" wrote in message
...
You could also use the DATEDIF formula. =DATEDIF(Date1, Date2, Interval)

http://www.cpearson.com/excel/datedif.aspx



"MillyD" wrote:

How do you work out how many days there are between to dates using a
formula

E.g.
11 march 1973
18 Feb. 1977


Thanks