Link date from one tab to another

[wjb1976]

Hi

This is my first thread. I use excel for work to programme projects and currently have a spreadsheet for holidays and operatives availability. On top of this spreadsheet I have a programme tab where I have address details, time on site, start date and all dates for the year accross the top. A couple of questions please if I could, firstly when I input a date and time on site would this auto fill under the correct date taking into account the weekend and also when I assign an operative(s) with their initials could this make the operative unavailable on availability tab?

Thanks

Will

[mikeTRON]

Mock up what you would look everything to look like and function and the forum can help you make it happen.