Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating dates | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
calculating dates | Excel Worksheet Functions | |||
calculating with dates | Excel Discussion (Misc queries) | |||
Calculating dates | Excel Discussion (Misc queries) |