repeating formula on calendar

  • Thread starter Thread starter Anne Jo
  • Start date Start date
A

Anne Jo

I have a work calendar that is 6 days on, 3 days off throughout the year.
The first five days are 1830-0300 hours, the 6th day is 1830-0230 hours, then
3 days off. I have a 12 month calendar typed in, but can't seem to get the
correct formula to have this carry forward day after day, to week after week,
to month after month.
 
Its its working fine as you drag down the =B2 and your every 6th day
and 3 days will be updated accordingly ........ what type of problem
you are having ????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

workday calendar 1
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Formula to Compute Overtime hours 1
vlookup and calculation questions 2
Excel formula 2
Adding up total hours worked on employee schedule using various criteria 0
Counting text problem - formula works initially 3
Importing cells frmom a calendar workbook 4

Back
Top