Forum Discussion
Solved
Sp Calculated Dates with a twist
I am trying to create a calculated date column that does the following: 1) Adds one month to a column that contains a date 2) Resets the day portion of the date to a specific number (like the 6th o...
Try without Day function for day, it should work:
=IF(Frequency="monthly",(DATE(YEAR([Last deliverable date]),MONTH([Last deliverable date])+[Date Calculation Input],[Due Day of the month])))Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
Try without Day function for day, it should work:
=IF(Frequency="monthly",(DATE(YEAR([Last deliverable date]),MONTH([Last deliverable date])+[Date Calculation Input],[Due Day of the month])))
Hope it will helpful to you and if so then Please mark my response as Best Response & Like to help others in this community
That works--thank you for your help.