Can't add days to a Date
Hi,
It seems like I cannot add days to a date by a formula.
Formula is below:
=[CX Finish Date (F)]@row + 2
And see the Screen shot below, above formula adds the number "2" to the end of the date as a text. However, it is expected to have 2 days added up to the date that was selected.
Thank you in advance.
Best Answer
-
Kelly, thank you very much, I don't know how I missed this but CX Finish date was not formatted as date regardless it looked in the date format as it is pulling the data from another sheet (linked). I just changed the column properties to date and the initial formula worked. Thank you for the heads up.
Answers
-
Hey @Cemil Binlik
Is your [CX Finish Date (F] based on a calculation?
Try this.
=VALUE([CX Finish Date (F)]@row) + 2
Did that work for you?
Kelly
-
Kelly, thank you very much, I don't know how I missed this but CX Finish date was not formatted as date regardless it looked in the date format as it is pulling the data from another sheet (linked). I just changed the column properties to date and the initial formula worked. Thank you for the heads up.
Help Article Resources
Categories
Check out the Formula Handbook template!