Calculating Projected Dates
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 |
Calculating Projected Dates
One way:
G1: =DATE(YEAR(B1), MONTH(B1)+1, DAY(B1)) In article .com, 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 |
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 |
All times are GMT +1. The time now is 01:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com