Hello! I have a project for work and I'm stuck.
Here's what I'm trying to do: I want to make a tool where you can type in what you need to get done, how often it needs to happen, and when it starts. Then, the spreadsheet will make a timeline and a calendar based on that info. I think I might need to use VBA, but I'm hoping I can do it without that. If not, no big deal, I'll adjust.
For example, you'd type in your tasks and dates like in the picture below. Then, the spreadsheet would show you when everything's due. I'm pretty confident about making the calendar and using conditional formatting to mark the dates, though, I am open to alternatives, but I'm stuck on how to make the dates work right. They need to skip weekends and holidays - pushing those deliverables to the next business day and stay in order.
And just for additional information, Eventually I'll add a macro to print to pdf.
Any help would be greatly appreciated!
Capture.PNG
Bookmarks