Date Formula Assist
I have a secondary date column (called "Review Date") that populates a date one year from an existing date column. I'm using a helper column called "AddYear" which will always display a 1 based on a new row entry. This formula is working to give me the new date (one year later) in the new column:
=DATE(YEAR([Date Column]@row) + AddYear@row, MONTH([Date Column]@row), DAY([Date Column]@row))
I'm also trying to incorporate this logic (to keep the new date column blank if the original date column is blank):
=IF([Date Column]@row = "", "")
Any ideas on how to combine these two formulas to give me the future date if a date is available in "Date Column" and keep the future date column blank if the "Date Column" has not been populated?
Help Article Resources
Check out the Formula Handbook template!