Making date projections..

[PWinkz]

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..

[benishiryo]

hi PWinkz, try in D2:
=EDATE($C2,6)
and in E2:
=EDATE($C2,12)

Edit: if you don't want anything to show up when C2 is blank:
=IF($C2="","",EDATE($C2,6))

[PWinkz]

Thanks a lot Benishiryo, this worked just fine....

Regards,
Pwinkz

[PWinkz]

hi PWinkz, try in D2:
=EDATE($C2,6)
and in E2:
=EDATE($C2,12)

Edit: if you don't want anything to show up when C2 is blank:
=IF($C2="","",EDATE($C2,6))

thanks for the help man. could you also help me with something else? I would like that when i put in the formula and the dates turns out to be a weekend, the next weekday date appears instead.

Thanks...

[benishiryo]

you're welcome
=WORKDAY(EDATE($C2,6)-1,1)
or
=IF($C2="","",WORKDAY(EDATE($C2,6)-1,1))

[PWinkz]

thanks again, You have been of great help...

regards,
Pwinkz..

[sagrok]

Hi Benishriyo,

Can we make this same and i need the color bar..

Eg.

first date 00/00/00 and the end date is after 7 days so between these 7 days the colored bar or colored cell i need

could you help me to do that...