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

hi
subtact the larger date from the smaller date. format as general.

regards
FSt1

"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

You can just subtract the smaller (earlier) date from the later date.
But, imagine you had 1 Jan 2008 in A1 and 3 Jan 2008 in B1. The
formula B1-A1 will give you a result of 2, but if you want to include
the start and end dates then you will have to add one on. Similarly,
if you want to exclude the start and end dates you need to subtract 1:

=B1-A1-1

Hope this helps.

Pete

On Aug 14, 2:58*pm, "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

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

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