Finding whether a date falls between a certain category

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I have 3 dates, a date that the patient attended the hospital and a range of
dates. I need a formula that tells me whether the date the patient attended
the hospital falls between the range. How do I best go about doing this?

Thanks
 
=IF(AND("Attendance Date">="StartDate","Attendance
Date"<="EndDate"),"Attended","Did not attend")

HTH
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help with SUMPRODUCT & converting date to value 1
Help needed to create a query 0
Counting days comparing 2 dates excluding empty cells 4
IF - Date falls between two dates, place here 3
Need help with formula to weed out duplicates 4
Excel Help with dates 2
I NEED HELP 1
date range within a date range 2

Back
Top