Forum Discussion
need to determine days between two dates
need a formula that will give me number of days between two dates
6 Replies
- Didn't work...2E is an established date, whilst 2F is todays date. need numbers of days between these two cells. Thanks...
=DATEDIF(E2;F2;"d")-1
You can subtract one day to return the number of days between the two dates. Depending on your version of Excel you might have to replace "; " by ", ":
=DATEDIF(E2,F2,"d")-1
