Date Formula error

jacquedale

Hi all,

Thank you all in advance.

Hi all, I have successfully used various date formulas in the past but for some reason I am running into a issue with a very simple formula. I am trying to add 14 days to a date (this will end up being a column formula).

Specially I need to add 14 days (which will display in the "forecasted" column) to the "received date". Wen I use the basic formula "=Received@row + 14" I received an error message of "Invalid Column Value"

My screenshot is attached.

ShelbyWarren

@jacquedale You might check to see if both columns are Date columns

ShelbyWarren

@jacquedale You might check to see if both columns are Date columns

jacquedale

Ugh, LOL I knew it was something simple I was overlooking. @ShelbyWarren That did the trick thank you.

Its already been one of those weeks. 🤣

ShelbyWarren

I've been there and done that. Glad it worked out 😀