Edate formula

I want to calculate the contract expiry date based on the current contract term.

If the day of start date <=15, the expiry date should be the last day of the previous month

if the day of start date is the expiry date should be the last day of the current month

any help would be great

thank you

Tags:

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!