Forum Discussion

Bruce Yim's avatar
Bruce Yim
Copper Contributor
Jan 19, 2023

Calculate between two date

Hello every one, please help me with the formula between two date I have three column A B and C, at C Column i want to calculate between A and B with 3 Month earlier result. Please look to column C...
excel
Valentin_Radu's avatar
Valentin_Radu
Copper Contributor
Jan 19, 2023
In my opinion, to calculate that, what you need is only the "end date". You can use the formula: EDATE(END DATE, -3). After that only change into DATE formatting and it is finish.
  • Valentin_Radu's avatar
    Valentin_Radu
    Copper Contributor
    Jan 19, 2023
    Maybe your DATE is not formatting in the correct way. I have tried one more time in my excel sheet and it's working.

Resources