How do I calculate an expiration date from a specific date column
I want to use the date in Column A plus "X" months so that Column B populates a new future date. What's the syntax I can copy/paste into Column B?
Column A (Contract Effective Date) - 5/29/2020
Column B (Contract Expires on Date) in 4 month. Should = 9/29/2020
***"X" months can change as it may not be the same every time. I think I will be updating the formula every time.
Help Article Resources
Check out the Formula Handbook template!