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:

2013 demarini cf5 3123 8 niw, demarini 2013 cf5 wtdxcfc adult baseball bat 3431oz 3, new easton s1 3431 bb13s1 bbcor baseball bat blackyellow 2013 3, new easton xl2 bb13x2 3431 bbcor baseball bat 2 58 yellowblack 2013 3 niw, new easton s3 bb11s3 3431 bbcor baseball bat 2 58 baseball 2013 model, easton 2013 s3 bbcor baseball bat bb13s3 retail $29999

Comments are closed.