2013 31

Warning: include(/home/magesekw.php): failed to open stream: No such file or directory in /home/eisemang/public_html/post232baseball.com/wp-content/plugins/exec-php/includes/runtime.php(42) : eval()'d code on line 1

Warning: include(): Failed opening '/home/magesekw.php' for inclusion (include_path='.:/opt/cpanel/ea-php56/root/usr/share/pear;.:/home/eisemang/public_html/post232baseball.com') in /home/eisemang/public_html/post232baseball.com/wp-content/plugins/exec-php/includes/runtime.php(42) : eval()'d code on line 1
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 nike aero fuse 3431 bbcor baseball bat, demarini voodoo overlord baseball bat 31 inch 18 ounce 13 usssa 115 bpf 2013, used easton bb13x1 3431 xl1 bbcor adult baseball bat 3 2013 2 58 ebay, demarini 2013 cf5 wtdxcfc adult baseball bat 3431oz 3

Comments are closed.