A Date Query

[SamuelT]

I need to create a formula which can do the following:

IF the end date (S2) is greater than than 12/31/05, AND the start date
(R2) is less than 12/31/05 then...(and I know the formula for here).

Any ideas? Thanks?

Sam B

 

[swatsp0p]

try this:

=IF(AND(S2>DATE(2005,12,31),R2<DATE(2005,12,31)),IF TRUE,IF FALSE)

Good Luck

 

[SamuelT]

Many thanks. That's working a treat!!!

 

[swatsp0p]

I'm glad it worked for you. Thanks for the feedback, it is always
appreciated.

Cheers!