need to determine days between two dates

Copper Contributor

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

6 Replies

@KevinR1335 

=DATEDIF(A2;B2;"d")

You can try this formula.

datedif.JPG

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

@KevinR1335 

 

=F2-E2

 

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

didn't work

@KevinR1335 

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?

@KevinR1335 

=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

datedif.JPG