If Date is between

[JasmineL]

I've done this formula a million times in other positions and I can't remember for the life of me the correct ordering.

Here's what I have:

1) Actual Date ($D4)
2) Beginning Date (F1)
3) Ending Date (F2)

What I need:
If Actual Date is on or later than beginning date and before or on ending date, enter ok, otherwise blank.

I know the formula is something like:
=IF(AND(F1>=$D4,$D4<=F2),"ok","")

I think I have the ordering off because right now my formula is returning "ok" for when the actual date is 3/11/11 and the beginning/ending dates are 4/1/11 and 4/30/11 respectively.

 

[Excelestial]

=if(and($d4>=f1,$d4<=f2),"ok","")

 

[JasmineL]

This is what I had before, but for some reason, the formula fills "ok" in the february column, even if the actual dates do not fall in february...thoughts? I wonder if it's a leap year thing.

 

[JasmineL]

Disregard, I changed my end Feb date to 2/28/2011 and everything corrected. How do you handle leap year?

 

[Excelestial]

Excel has its own internal clock and calendar. It recognizes leap year as occuring in 2012 and will list it as part of a given date sequence. ..so I'm not sure what you mean by "how do you handle" leap year.