Excel To Count the number of days?

  David4637 16:25 20 Feb 10
Locked

Please give me the syntax to provide the answer of 31 days in Column C?

Column A 01/03/10

Column B 31/03/10


Column C 31

Obviously I need to count the difference between odd dates, the above is to make it easy to understand what I require.
Thanks David

  VoG II 16:27 20 Feb 10

Try

=B1-A1+1

Format the result cell as Number.

  MAJ 16:27 20 Feb 10

The Datedif function. click here

  David4637 17:00 20 Feb 10

Thanks both for a very fast reply. Tried VOGs - works fine, but will look at Maj as well.
Thanks again both David

  David4637 13:26 21 Feb 10

MAJ - your link also works, without having to add an extra day to make 31 days.
Thanks again to you both. David

  MAJ 13:39 21 Feb 10

Sorry David4637, Datedif gives the number of days/months/years between the dates, not the inclusive days.

  David4637 13:59 23 Feb 10

Yes you are right I did have to add +1 to give me the inclusive days at start and end of the period. Thanks again. David

This thread is now locked and can not be replied to.

Hands-on: Samsung Galaxy S8 review

1995-2015: How technology has changed the world in 20 years

Samsung's beautifully designed Galaxy S8 makes for better VR experiences too

47 iPhone camera tips to help you take better photos