B bhagwan New Member Sep 13, 2011 #1 if any employee joined the company before 01/01/2000 he consider seniour otherwise juniour
oldchippy Active Member Sep 13, 2011 #2 Hi, Join date in A1, 01/01/2000 in B1, then in C1 =IF(A1<B1,"Senior","Junior")
