I'm using the Days function to calculate the number of days between certain dates.
Days function does not include 1 of either the start of finish date. Thus if I input [ A1]01/01/15 [A2]31/01/15 [A3]=days(A1,A2) A3 returns 30 as per attachment.
similarly 01/01/15 - 31/12/15 = 364.
It would be be a simple matter to modify the return to =days(A1,A2)+1 however I wondered if there was a better function available?
You can simply subtract:
=A2-A1+1
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
You can use DATEDIF function:
=datedif(A1,A2,"d")
https://www.youtube.com/watch?v=PaD1P1QwnB4
Last edited by John90; 09-02-2015 at 10:11 PM.
You still have to add 1.Originally Posted by John90
=DATEDIF(A1,A2,"d")+1
Book1.xlsx=DATEDIF(A2,B2,"d") returns 30 days as per attached sheet this post.
Yes, but you said this:
So I assume you want to count every day in the range. If so, then, no matter what method you use you'll have to add 1.
Ok thanks tony. you've confirmed what i suspected. It seems odd to me that [DAYS] does not count all days within a range. I can cope with adding +1 to the formula. I just wondered if there was a better/different/accurate option.
You're welcome. Thanks for the feedback!
If your question has been solved please mark the thread as being solved.
In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks