Forum Discussion
Solved
Add months to date
Hi, Im trying to add dates in a calculated column to a date. For example, I have date 1.5.2021 in Column A and 24 months in column B. I want the result to be 1.5.2023 in column C. However, for so...
This can be quite tricky as the dateadd function requires a column reference and that column needs to have the date that would be the result of your addition. The simplest way to do this is to use the EDATE function so some thing like
NewDate = EDATE([Column A],[Column B])
# EDATE only works for months but that works fine in your case.
This can be quite tricky as the dateadd function requires a column reference and that column needs to have the date that would be the result of your addition. The simplest way to do this is to use the EDATE function so some thing like
NewDate = EDATE([Column A],[Column B])
# EDATE only works for months but that works fine in your case.