Between Dates

[How_Do_I]

I’ve confused myself a little with the last question I asked….

I want to return TRUE in C2 if:

A date in A2 is equal or greater than 01/01/1917 but less than 31/12/1917

A date in B2 is equal or less than 31/12/1917 but greater than 01/01/1917

How would I do that please…?

 

[gaz_chops]

So TRUE if both A2 & B2 meet your criteria, otherwise FALSE.

 

[gaz_chops]

If so try

=AND(A2>=C1,A2<D1,B2>C1,B2<=D1)

 

[How_Do_I]

That's looking good, thanks Gaz...!

 

[gaz_chops]

You're welcome.

Meant to add this so you could see what was in C1 & D1