Forum Discussion

Copper Contributor

Aug 17, 2023

Count date difference in months from today

How can I count the month difference from today to a specific date in the past?

Formulas and Functions

3 Replies

OliverScheurich
Gold Contributor
Aug 17, 2023
csambo
This can be done with the DATEDIF function.
DATEDIF function - Microsoft Support
- csambo
  Copper Contributor
  Aug 17, 2023
  But in which formulation I need to put the today's date as start date?
  - OliverScheurich
    Gold Contributor
    Aug 17, 2023
    csambo
    =DATEDIF(C2,D2,"m")
    I'd reference the cells which have the start date and today's date.

Resources