Require Excel formula or workout for date wise booking and availability

[Jaspreet Singh]

Hi,

I handle an inventory of 2000 devices across 20 centers and book them date wise as required by projects in the organization. I am looking out for an excel workout where i can book devices with start date and end date and check the current availability across all centers.

Also to plan my work better, i would like to have the same for next 30 days or atleast 15 days.

Any help on this will be highly appreciated.

Regards,
Jaspreet

[Pepe Le Mokko]

Hi
please post a sample sheet - Thx

[Jaspreet Singh]

Here is the sample :-)
Device Booking Log_1.xlsx