Formula and dates

Patricia Worth

Hi all

I have a date column that is a formula (10/12/18 + 60 = 12/11/18) I need to add 6 months to that date, but when i try to add 182 to the 12/11/18 date i get Invalid Column Value. What am i doing wrong?

Brian W

It sounds like your column property is set to Text/Number. If you click the arrow underneath the column header it should say Current type: Date at the bottom. If it doesn't you can Edit Column Properties there.

Patricia Worth

figured it out... the column was not a date column... all good now.. thank you!