Formula Help Please

[Rodney]

When I paste a take out sample into VLookup,
I need the response from the array to indicate 14 days either side
of the dates pasted, both 1 year and 2 years prior with "!seed sow window"

The following works fine with 1 year prior,
=IF(AND($A$47057-D2>351,$A$47057-D2<379),"!seed sow window","")

Can someone add/include the appropriate statement to show(include) 2 years prior please?
(eg(AND($A$47057-D2>716,$A$47057-D2<744),"seed sow window","")

(the day parameters are 716 low and 744 high)

Thank you very much.

(e-mail address removed)
(Remove gum to reply)

 

[Dreamboat]

Without testing, I believe that would be

=IF(AND($A$47057-D2>351,$A$47057-D2<379),"!seed sow window",if(AND($A$47057-D2>716,$A$47057-D2<744),"seed sow window",""

Otherwise, you may need to reverse the two portions of the formula

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*-
Anne Tro
Author: Dreamboat on Wor
Email: Dreamboat*at*Piersontech.co
Web: www.TheOfficeExperts.co

 

[Rodney]

G'day Anne,
Thank you for your assistance,
it worked a treat,
Your formula just lacked a further bracket at the end :0)

Rodney