Oct 18 2022 09:59 AM
need a formula that will give me number of days between two dates
Oct 18 2022 10:07 AM
Oct 18 2022 10:16 AM
Oct 18 2022 10:33 AM
Oct 18 2022 11:06 AM
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?
Oct 18 2022 11:23 AM
=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