Forum Discussion
Auto Date advance
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 t...
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