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

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

That worked great. how would i work this one?

if Difference is greater than 30, then New Covg should be first of the month
following Rehire Date plus 3 months; unless Rehire Date is on the first, in
which case New Covg should be the Rehire Date + 3 months

"Miguel Zapico" wrote:

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