how do you

  • Thread starter Thread starter MillyD
  • Start date Start date
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
 
hi
subtact the larger date from the smaller date. format as general.

regards
FSt1
 
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
 
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.
 
You must log in or register to reply here.

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 to determine the highest occurrence? 4
dates of month automation 3
copying & incrementing formulae across open worksheets 4
calculate number of days 7
Expanding Date formula 1
Formula for counting events 5
COUNT using 2 different criterias 5

Back
Top