Calculating Projected Dates

J

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
 
T

Teethless mama

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))
 
Top