Auto Date advance

Occasional Visitor

I need to set up a table for client assessments that are due every 5 months. How do I formulate a cell so that when an assessment is completed and I click on that cell, it will automatically update to the date 5 months from now?  

I hope I have explained this clearly!

 

TIA for your help!

1 Reply

let's say you enter today's date in column A and other data in columns B-D and you want column E to be a date 5 months from column A then let's assume you are on ROW 2 then you can use this formula in column E:
=EDATE(A2,5)

NOTE: this formula does not check for weekends or holidays, just purely original date + 5 months