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...
Hi Expiscornovus
Thank you it worked. But how can I enter the formula for a blank if criteria does not meet.
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)," ")