Lookup Year Date and Time

[BJ576]

I have this starting workbook. The 'Other Events on a Specific Day of the Year' could be used for appointments.

 

[vletm]

few ... ?
a) Why each month has own sheet? ... How many sheets can You see one time?
b) Could You data-sheet be like? --- One task - start date/time, length, CustID, 'what' - per row in data
c) Holidays --- Other 'non'-tasks as some specific days and so on
>> those could show as in Your 'calendar'-sheet - monthly and per day with details.

... but, of course ... You're doing that for Yourself

 

[BJ576]

So far look at row 64 on Events sheet. I think this may work with some adjusting. I could hide the other rows above to make it easier for data entry. These will now show on the calendar month for appointments.

 

[vletm]

BJ576
... still one ... idea of layout
I've used this kind of weekly calendar layout.
Note: Now, this is only rough sample of layout.
Week selection could do with left side calendar ..
There (left) could colors to show different tasks.
Week-layout could show daily task based time.
... of course, the data = tasks are now missing and so on ...

 

[BJ576]

Thanks I will use the one I provided earlier.