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.
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. Read More