Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Orig Hire Date Term Date Rehire Date Difference New
Conv Date 09/15/2005 03/22/2006 04/15/2006 24 04/15/2006 if Difference is less than or equal to 30, then New Covg should be first of the month following the Rehire Date unless Rehire Date is on the first, in which case New Covg should be the Rehire Date does anyone have an idea on how to do this. i have some ideas but wondering if they will work. thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Insert Automatic, Non-Updating Date Stamp | Excel Discussion (Misc queries) | |||
Need to Improve Code Copying/Pasting Between Workbooks | Excel Discussion (Misc queries) | |||
Date formulas needed | Excel Discussion (Misc queries) | |||
Min/Max formulas using cells with date format | Excel Worksheet Functions | |||
Using formulas to determine date in one cell based on date in anot | Excel Worksheet Functions |