Forum Discussion
need to determine days between two dates
need a formula that will give me number of days between two dates
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
- didn't work
A tad more information than "didn't work" might be helpful.
What do the cells involved contain? Real dates or text values that look like dates?
