Forum Discussion
Add days to Calculated Columns base on Number of Months
Hi, Please help me with this calculated formula. I am currently creating a sharepoint list for payment monitoring. I have columns: Months to Pay (number), First Payment(date), Second Payment(d...
Rowell2022 you can use the date and day formulas to add number of days.
Below is an example for your setup
In this example I am using the Second Payment date if the months is less than 3 btw. Don't know what you want to use in that case?
=IF([Months to Pay]>=3,DATE(YEAR([First Payment]),MONTH([First Payment]),DAY([First Payment])+60),[Second Payment])
- Hi Expiscornovus
Thank you it worked. But how can I enter the formula for a blank if criteria does not meet.Rowell2022 if you want to leave it empty you can just use
" "Below is an adjusted example
=IF([Months to Pay]>=3,DATE(YEAR([First Payment]),MONTH([First Payment]),DAY([First Payment])+60)," ")- You've helped me a lot, Thank you, Expicornovus!
