Calender Dates

[Hemish]

Hi

I am trying to create dates in excel sheet, so when the year changes the day and dates change. But i only want to show the working days Monday to Friday going across in columns

Eg Year 2012

02/01/2012 03/01/2012 04/01/2012 05/01/2012 06/01/2012 09/01/2012 10/01/2012 11/01/2012 12/01/2012 13/01/2012
Monday Tuesday Wednesday Thursday Friday Monday Tuesday Wednesday Thursday Friday



I would like either in formula or macro when i change the year the dates change. I know there are not enough columns so will have each sheet by month or quarter

Thanks

[jeffreybrown]

Hello & Welcome to the Forum,

Have you looked at the Workday function =WORKDAY(start_date,days,holidays)

For the start_date you can enter the year, but have it be 1/1/2012 but displayed as yyyy and your good to go.

[Ron Coderre]

Try this

Please Login or Register  to view this content.

which calculates the first workday of that year.
If you have this list of holidays in Sheet1!A1:A12

Please Login or Register  to view this content.

then this variation will skip those holidays when calculating workdays:

Please Login or Register  to view this content.

For the remaining days, enter one of these regular formulas (depending on whether you're using a holiday list or not) and copy it across to the right

Please Login or Register  to view this content.

For 2012, this is the series of workdays (excluding the holidays I listed):
Friday, January 13, 2012 Monday, January 16, 2012 Tuesday, January 17, 2012 Wednesday, January 18, 2012

Notice that January 1st through the 12th is skipped because I listed them in the holidays.

Is that something you can work with?

[Hemish]

Hi thank you both of you for your tips.

I will try this .

Once again thank you