check between two dates

[bajdr47]

afternnon All,

i have a column of names. i have two corresponding columns of Dates ie "Date from" and "date to".

i would like to insert a formula in the "K2" cell in the attached sheet, to identify if a person was in attendance on a particular date. based on name and the date specified.


Many Thanks

BR

thank you gentlemen,

both options work perfectly....but the non sort option is my preferred one

BR

[ZENITH]

Try this code in K3 and let me know if you have any problems with it.

Please Login or Register  to view this content.

You also need to format I3 to be a date.

[Richard Buttrey]

Hi,

If you're prepared to sort the table by column B date ascending - how about

Please Login or Register  to view this content.

Regards