Forum Discussion
Custom calendar dates
Hi,
I'm trying to create a custom calendar for staff timesheets. Our payroll require the dates to run 6th of each month to the 5th of the next month to fall in line with the tax year. How do I edit a template to show those dates. For example, 6th November to 5th December under the month of November.
Effectively, I need to shift the weeks up and then auto display the rest of the dates in December up to 5th. Ideally I would then custom to make the dates outside the payroll month invisible. That then leaves it clear for employees to add their hours worked for each day to generate the weekly and monthly hours (as already formatted)
Thanks in advance
6 Replies
See if you can adapt the attached calendar (based on one of Microsoft's templates) for your purpose.
- Thank you, that certainly looks like a better calendar for this application. I suppose it would be a case of trying to work out how to adapt that to start and finish on a certain date or just to remove dates each side possibly? This one is using an NDX formula so I'll have a play around
You can play with the shading and/or conditional formatting to hide the dates outside the desired period.
