Forum Discussion

Copper Contributor

Oct 18, 2022

need to determine days between two dates

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

Formulas and Functions

OliverScheurich

Gold Contributor

Oct 18, 2022

=DATEDIF(A2;B2;"d")

You can try this formula.

KevinR1335
Copper Contributor
Oct 18, 2022
Didn't work...2E is an established date, whilst 2F is todays date. need numbers of days between these two cells. Thanks...
- OliverScheurich
  Gold Contributor
  Oct 18, 2022
  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
- HansVogelaar
  MVP
  Oct 18, 2022
  KevinR1335
  
  =F2-E2
  
  Format the cell with the formula as General or as Number.
  - KevinR1335
    Copper Contributor
    Oct 18, 2022
    didn't work

Resources