Finding whether a date falls between a certain category
 

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
--
Johanna G

Finding whether a date falls between a certain category
 

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

HTH

"Johanna Gronlund" wrote:

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
--
Johanna G