Need help with date function/formula

**snaffles** · 08-08-2012, 08:39 PM

Hi Everyone,

This may be simple but its my brick wall!

My spreadsheet has a date (random) in cell A1 and i want to show (by entering the number 1)in cell A2 if that date is before a specific, constant date (2/29/12). If it is not before 3/1/12 then I want to show 0 in cell A2.

The random date is a hire date and the specific date is an eligibility deadline.
I also need to show if a second deadline of pre-8/31/2010 is reach by similarly entering a 1 or 0 in cell A3.

I've tried IF functions but not sure how to enter the dates. Any help greatly appreciated!

**FDibbins** · 08-08-2012, 08:55 PM

with your fixed date in J2 and your random date in J3, try =IF(J3>J2,0,1). you may have to swap the ,0,1 around to suite your needs

**snaffles** · 08-11-2012, 10:28 AM

Thanks for your speedy reply, it did work for me.
I had been trying to incorporate the fixed info (date )within the formula rather than using the cell reference but that was just too much!