Forum

Notifications
Clear all

Date Match Inquiry

2 Posts
2 Users
0 Reactions
82 Views
(@moldboy)
Posts: 1
New Member
Topic starter
 

I have a Workbook with a Date Cell that I use to schedule date & times when Clients request specific schedules. I also have a Calendar Workbook that I enter a Time and Date which posts into the Calendar information. What would hope to produce is a lookup or match or? That when I post a date in the calendar and save, I then could enter any date in my other workbook and if the dates matched, I would have a popup or something.

My best explanation of what I'm asking is when you call in for a hotel reservation and tell them at date, they plug that date in for all their rooms for availability, a window pops up and tells them if rooms will be available or not. 

Again I have One workbook that I enter information into with a date they request, then I have a separate workbook with a calendar that I plug the requested date into. Just want a warning when I enter the clients date requested that I know if that date is available without searching through my workbooks.

Thank You

 
Posted : 09/08/2020 3:05 pm
Philip Treacy
(@philipt)
Posts: 1631
Member Admin
 

Hi Steve,

without your workbooks it's impossible to write a formula for you!

Regards

Phil

 
Posted : 09/08/2020 6:04 pm
Share: