0

I am trying to create a calculated column that adds 15 days to the EndDate field and then output it with a YYYY/MM/DD format, but I am not getting the desired results. Here is what my column looks like:

=(YEAR(EndDate)&"/"&MONTH(EndDate)&"/"&DAY(EndDate+15))

what is possible wrong?

1 Answer 1

3

SharePoint stores dates as integer count starting at 1/1/1900

So

=EndDate + 15

gets you 15 days from your EndDate

To format Dates different you can use the TEXT() function

=TEXT( EndDate+15 , "YYYY/MM/DD"  )

Function documentation: https://www.365csi.nl/vm365com/365coach/#/Calculated_Column_Functions_List

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.