Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES
I am having trouble finding a way to have a specific date print based off
critera from an employee hire date. I have two future dates that I need to print, both based off the hire date, one is six months from hire date, the other is one year from hire date. I am able to calculate the exact dates just fine, however, the date that I need to print for the one is the first day of the following month after the six month anniversary, and second is either July 1 or Jan 1, whichever comes first after the one year anniversary date. Can anyone help me in calculating/printing these two dates? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES
For a hire date in A1....Try this:
First day of the month after the 6-month period: B1: =DATE(YEAR(A1),MONTH(A1)+7,1) earlier of July 1 or Jan 1 after the anniversary date: C1: =DATE(YEAR(A1)+1,1+(INT((MONTH(A1)-1)/6)+1)*6,1) Does that help? *********** Regards, Ron XL2002, WinXP "MarkT" wrote: I am having trouble finding a way to have a specific date print based off critera from an employee hire date. I have two future dates that I need to print, both based off the hire date, one is six months from hire date, the other is one year from hire date. I am able to calculate the exact dates just fine, however, the date that I need to print for the one is the first day of the following month after the six month anniversary, and second is either July 1 or Jan 1, whichever comes first after the one year anniversary date. Can anyone help me in calculating/printing these two dates? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES
"MarkT" wrote in message ... I am having trouble finding a way to have a specific date print based off critera from an employee hire date. I have two future dates that I need to print, both based off the hire date, one is six months from hire date, the other is one year from hire date. I am able to calculate the exact dates just fine, however, the date that I need to print for the one is the first day of the following month after the six month anniversary, =DATE(YEAR(A2),MONTH(A2)+7,1) and second is either July 1 or Jan 1, whichever comes first after the one year anniversary date. =DATE(YEAR(A1)+1,(INT((MONTH(A1)-1)/6)+1)*6+1,1) |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES
That worked pefect! Thank you very much.
Mark "Ron Coderre" wrote: For a hire date in A1....Try this: First day of the month after the 6-month period: B1: =DATE(YEAR(A1),MONTH(A1)+7,1) earlier of July 1 or Jan 1 after the anniversary date: C1: =DATE(YEAR(A1)+1,1+(INT((MONTH(A1)-1)/6)+1)*6,1) Does that help? *********** Regards, Ron XL2002, WinXP "MarkT" wrote: I am having trouble finding a way to have a specific date print based off critera from an employee hire date. I have two future dates that I need to print, both based off the hire date, one is six months from hire date, the other is one year from hire date. I am able to calculate the exact dates just fine, however, the date that I need to print for the one is the first day of the following month after the six month anniversary, and second is either July 1 or Jan 1, whichever comes first after the one year anniversary date. Can anyone help me in calculating/printing these two dates? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
DATES
Awesome, that worked great! Thank you so much.
"Bob Phillips" wrote: "MarkT" wrote in message ... I am having trouble finding a way to have a specific date print based off critera from an employee hire date. I have two future dates that I need to print, both based off the hire date, one is six months from hire date, the other is one year from hire date. I am able to calculate the exact dates just fine, however, the date that I need to print for the one is the first day of the following month after the six month anniversary, =DATE(YEAR(A2),MONTH(A2)+7,1) and second is either July 1 or Jan 1, whichever comes first after the one year anniversary date. =DATE(YEAR(A1)+1,(INT((MONTH(A1)-1)/6)+1)*6+1,1) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dates and Intervals | Excel Worksheet Functions | |||
formula to add dates. | Excel Worksheet Functions | |||
need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Formating Dates for production schedule | Excel Discussion (Misc queries) |