Calculating Projected Dates
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))
" wrote:
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
|