Forum Discussion
Bruce Yim
Jan 19, 2023Copper Contributor
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...
Valentin_Radu
Jan 19, 2023Copper Contributor
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
Jan 19, 2023Copper Contributor
Maybe your DATE is not formatting in the correct way. I have tried one more time in my excel sheet and it's working.