2013 31

How to make the dates change in Excel each month?

I Have a worksheet which has the days of the month in the rows. (01/01/2013, 02/01/2013,.....31/01/2013). I need to use this worksheet every month and I would like that the dates change automatically according to the particular month. ALso, it would be great if I could skip the dates of Saturdays and Sundays. Is this possible?

One last edit, it has occurred to me that you may want to retain several sheets with this calendar. It would do no good to use the TODAY() function as I had originally used because it would change for every sheet every month. The [A2] formula allows you set the month and year in cell [A1] which will be static.
[A1] June 2013

It then bases the first work day of that month on the value in [A1].

[A2] --> = = IF( WEEKDAY( A1) > 5, A1 + MOD( WEEKDAY( A1), 5), DATE( YEAR( A1), MONTH( A1), 1))

[A3] --> =IF( A2="","", IF( IF( WEEKDAY(A2,1)>5, A1 + (9 - WEEKDAY( A2, 1)), A2+1)> EOMONTH( A2,0), "", IF( WEEKDAY( A2,1) > 5, A1 + ( 9 - WEEKDAY( A2, 1)), A2+1)))

Copy [A3] down to row 24.

You can see an example here.


@Blackened - June 1, 2013

Find 2013 31 On eBay Below:

Recently Purchased 2013 31:

new easton s1 3431 bb13s1 bbcor baseball bat blackyellow 2013 3, easton s1 3431 bb13s1 bbcor baseball bat blackyellow 2013 3, 2013 demarini vengeance vec12 3 31 inch 28 oz bbcor certified baseball bat, new demarini voodoo adult bbcor baseball 3128 vdc13 bat 3 drop 3 2013 niw, new easton bb13s4 s4 aluminum 3128 3 adult bbcor baseball bat 2013, new easton s3 bb13s3 3431 bbcor baseball bat 2 58 2013 3 adult, new demarini vnc13 vexxum 3431 bbcor baseball bat orangewhitegray 2013, rawlings bbca2 5150 alloy bbcor adult baseball bat 2013 31inch 28ounce, 2013 easton xl1 baseball bat 3128 hottest composite bbcor new lizard skin, easton 2013 s3 bbcor baseball bat bb13s3 retail $29999

Comments are closed.