need to determine days between two dates

New Contributor

need a formula that will give me number of days between two dates

6 Replies



You can try this formula.


Didn't work...2E is an established date, whilst 2F is todays date. need numbers of days between these two cells. Thanks...





Format the cell with the formula as General or as Number.

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?



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 ", ":