Thread: date formulas
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sunderland27
 
Posts: n/a
Default date formulas

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