Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
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) |