Hi guys,

I need to create a formula that takes an entered date and projects 6 months from that date and also in another cell projects 1 year from the entered date.

For example if I was to enter the start date of work, I would like a formula to automatically fill a cell with a date of 6 months from that day and another cell for 1 year(12 months) from that date. It is so when we put a date started it automatically gives me the next date for probation and a contract renewal date.

sample file here...date projections.xlsx

Thanks..