Displaying what is active today from different date periods

[andymarten]

Hi,

I am sure this is easy but I cannot find what I am looking for on YouTube or via any of the forums.

I would like to have a simple database where I can input periods of dates (from and to) and then have either a conditional format that colours the relevant dates, or a 'yes/no' 'tick/cross', for those that are active today.

Is this possible?

Thank you for your time.

Andy

[PaulM100]

You can use this formula for both conditional formatting and your range: =AND(B6<=TODAY(),C6>=TODAY())

[Pete_UK]

You can use this formula in D2:

=IF(AND(B2<=TODAY(),C2>=TODAY()),"Yes","No")

then copy down as required.

Hope this helps.

Pete

[andymarten]

Hi Pete,

it worked like a dream, thank you.

[andymarten]

Hi Paul,

thank you, that also worked.

Thank you both for your quick replies.

Andy