how do you

M

MillyD

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
 
P

Pete_UK

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
 
D

David Biddulph

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Countifs or a pivot 1
How can count the number of cells that fulfill certain criteria in other cells 2
number of months and days between two dates without approximation 3
Help showing active months between two dates 5
Expanding Date formula 2
Get the right language when inserting a date 2
using a year from a date 4
copying & incrementing formulae across open worksheets 4

Top