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? |
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? |
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) |
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? |
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) |
All times are GMT +1. The time now is 04:14 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com