Previous Topic Next Topic

If this date is before that date, then...

Closed
Danielle - Oct 27, 2010 at 03:52 PM
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 - Oct 27, 2010 at 06:21 PM
Hello,
I have an issue that involves employee hire dates.
These are my column headings:

A1 A2 A3 A4
HIRE DATE TERM DATE WORKING 01/01/06? WORKING 12/31/06?


I am trying to write an IF formula that will test whether an employee's HIRE DATE (A1) was prior to 01/01/06, and if it was, I want it to return the date in A1 in cell A3. If it was not, I want it to return "01/01/06" in A3.

I am trying to perform the same logical test for the term dates with 12/31/06 as the qualifier.

I hope this makes sense and someone can help me!

Thanks!

Danielle



1 response

Answer 1 / 1
RayH Posts 122 Registration date Tuesday August 31, 2010 Status Contributor Last seen June 20, 2016 26
Oct 27, 2010 at 06:21 PM 
Hire Date TermDate Working 01 Working 12 
date  =IF(A2<DATE(2006,1,1),A2,"") =IF(A2<DATE(2006,12,31),A2,"")

Not 100% clear on what to do for 12/31/2006.
This returns the date from A2 in C2 where it is less than 1/1/2006
This returns the date from A2 in C3 where it is less than 12/31/2006
0