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