A Date Query

S

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
 
S

swatsp0p

try this:

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

Good Luck
 
S

swatsp0p

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

Cheers!
 
Top