Thread: Calendar Population

Maybe this can get you started.

Starting in A3 you should enter actual dates to ensure a proper match.

The formula in A4 is a Ctrl + Shift + Enter formula

Thanks Jeff for your help, the thing is there might be 5 orders entered on January 1st, or even some carrying on from other months, so the date entered might not be the date it will be built.

For Ex: if i have 5 orders on january 1st @ 5 hours each, it should automatically allocate the next 25 hours of work for these orders, which would end up being just over 3 days.

I will continue to mess around with the sheet and post if i come up with something, thanks again for any help in advance

also, im not trying to find how much hours of work i have in a given day, but how many days of work i have based off of the projects

EDIT:

I think it might work better to look at VBA, that can read the sheet and process and enter it into the calendar instead of getting the calendar to use references in the cells.

Maybe a pivot table can be an option for you or even a gantt chart....

Also, it seems there are other factors to take into account, but one would be crew size.

In your example, 5 orders on the 1st of January @ 5 hours each comes up to the 25 hours and yes there are only 8 hours in the day, but how many people are available for the project?

There is a lot to consider before even thinking about VBA. All the mapping should be laid out with good examples so as not to have to stretch this out to far.