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(date).
I'm looking for a formula for the Third Payment, that if Months to Pay is greater than or equal to 3 will add 60 days from First Payment.
Hope anyone can help me with this. Thank you.
Please see attached image.
7 Replies
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)," ")
