D
Dax Arroway
I have a worksheet with Headers: A:Name, B:StartDate, C:Room#, and D:EndDate.
I'm looking for a formula that will check the availability of a room based
on EndDate. For example if I entered Mr. Smith on one row and gave him room
100 and he hasn't checked out yet (no EndDate) then when I go to the next
line and enter Mr. Black and try to put him into that same room, I'd like to
get an error or warning message saying, "Someone's already in that room!"
but if Mr. Smith had an EndDate, then it wouldn't give me that message.
I hope that makes sense. Basicall I'd like it to check the column for
duplicate entries and if, for those duplicate entries, if there's an EndDate
in the D column. If there's no EndDate, throw error message. If all matches
have EndDates, allow.
Any help???
Thanks in advance!
--Dax
I'm looking for a formula that will check the availability of a room based
on EndDate. For example if I entered Mr. Smith on one row and gave him room
100 and he hasn't checked out yet (no EndDate) then when I go to the next
line and enter Mr. Black and try to put him into that same room, I'd like to
get an error or warning message saying, "Someone's already in that room!"
but if Mr. Smith had an EndDate, then it wouldn't give me that message.
I hope that makes sense. Basicall I'd like it to check the column for
duplicate entries and if, for those duplicate entries, if there's an EndDate
in the D column. If there's no EndDate, throw error message. If all matches
have EndDates, allow.
Any help???
Thanks in advance!
--Dax