date formulas
You can try this one for New (supposing in cell E2)
=IF(D2<=30,IF(DAY(C2)=1,C2,DATE(YEAR(C2),MONTH(C2) +1,1)),"Greater than 30")
"sunderland27" wrote:
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
|