Finding whether a date falls between a certain category

J

Johanna Gronlund

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
 
T

Toppers

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

HTH
 
Top