Auto Date advance

[Eileen1080]

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!

[#2]

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