Please give me the syntax to provide the answer of 31 days in Column C?Column A 01/03/10Column B 31/03/10Column 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
Try=B1-A1+1Format the result cell as Number.
The Datedif function. click here
Thanks both for a very fast reply. Tried VOGs - works fine, but will look at Maj as well.Thanks again both David
MAJ - your link also works, without having to add an extra day to make 31 days.Thanks again to you both. David
Sorry David4637, Datedif gives the number of days/months/years between the dates, not the inclusive days.
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.
Galaxy Note 8 vs iPhone X
Awful clip art from 1994 is being tweeted every hour by a bot
iPhone X vs Samsung Galaxy Note 8
Les meilleurs navigateurs internet 2017
© Copyright 2017 IDG UK. All Rights Reserved.