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

Thank you.

excel

2 Replies

  • 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