Calculating Projected Dates

[jamesmcoats]

I know this should be simple... but I haven't used Excel in a while
and I can't figure this out.

I have a list of employees, their start dates, and 3 projected dates
(1 month, 3months, 6months).

I need to enter the employee's start date (Column B) and have column G
(1 month after start), H ( 3 months after start), and I (6 months
after start) all calulated.

I greatly appreciate some direction!

Thanks in advance

James

 

[JE McGimpsey]

One way:


G1: =DATE(YEAR(B1), MONTH(B1)+1, DAY(B1))

 

[Guest]

In G1: =DATE(YEAR(B1),MONTH(B1)+1,DAY(B1))
In H1: =DATE(YEAR(B1),MONTH(B1)+3,DAY(B1))
In G1: =DATE(YEAR(B1),MONTH(B1)+6,DAY(B1))