Dates on a Schedule

[telcotech]

I would like to have cells that I could put the Start and end dates of a schedule in and have the dates prepopulated and formatted at the top of the schedule automatically.

I was thinking it should be a template with 1 default week, put in the start and end dates and copy the 7 days for the duration of weeks needed. It must include and copy the formulas at the bottom of the spreadsheet also that have different formulas for weekends and weekdays.

This will always start on a Sunday and end on a Saturday and be full weeks.

Attached is a sample of what I am looking to do, if it can be done.

Thanks

[jasoncw]

Here is what I came up with. There is code in the Sheet1 module, as well as a general module. This will trigger if you make a change to either the begin or end date. Let me know how it works out.

Jason

[telcotech]

Oh YES, you are a genius. Thank you very much. This is exactly what I was looking for.

I have 1 more question about this, how do I put this into another existing worksheet?

Thanks

[jasoncw]

Glad it helped.

If you want it to work on a different sheet, you need to tell it which worksheet to manipulate. So you would change the following line:

Please Login or Register  to view this content.

You can also set up the code to work on the active sheet, as long as each sheet is set up identically, by changing the above to:

Please Login or Register  to view this content.

HTH

Jason

[telcotech]

Thanks,


Then just insert the code using the VB editor to place it in the Sheet1 module, as well as a general module. Right?

[jasoncw]

Yes, as long as the sheets are set up identically, then the code should work.