# dates for 4 day working week help

1. ## dates for 4 day working week help

hi, we work Mon - Thurs and what i want to do is have the dates for these days in a spread sheet ( see example )

so there are 8 products all with the same date that need carrying on for the next ? years.

I have manually done it for the example but cant get it to drag down correctly

any ideas

2. ## Re: dates for 4 day working week help

Hi,

you could write in B34

=b2+7

and copy the formula down

In column A, you should create a custom list from tools (A,B,C,D,E,F,G,Other) option list and then drag down the list.

Attached an example

Regards

3. ## Re: dates for 4 day working week help

Hi

Check the attached

I use supportive column to generate counting from 1 to 8 and then use i function

Regards

4. ## Re: dates for 4 day working week help

CANAPONE : i will check that the info is correct, unless you know otherwise. Thanks for the reply. What would i do to the formula to make a 5 day working week?

Mahju : when i copy the formula down it does not ommit Fri,Sat Sun as in Canapone example i wanted, unless i have done something wrong? Thanks for your reply

Much appreiciated.

5. ## Re: dates for 4 day working week help

Hi just write in B34:B41 January 6 2012 (Friday) and in B42

=B2+7

and copy down B42.

Regards

6. ## Re: dates for 4 day working week help

Thankyou so much CANAPONE for your quick responce.Ill check it out next week at work and close thread down. Thanks again

7. ## Re: dates for 4 day working week help

Hi
Check this one

adjusted for Fri, Sat and Sunday

Regards

8. ## Re: dates for 4 day working week help

Thanks Mahju for your reply.great stuff. Ill need a clear head for that calculation !!!! can you do one for a five day week too......

Hi
Sure

See attached

Regards

10. ## Re: dates for 4 day working week help

Thanks for the quick reply and other solution !!!

11. ## Re: dates for 4 day working week help

Dates checkout exactly as required, Thankd guys for the help

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1