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.
eg.
[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.

https://docs.google.com/file/d/0B4vNeXzOlnXmTEFLSk82M1QtbTQ/edit

@Blackened - June 1, 2013

Find 2013 31 On eBay Below:

Used Easton BB13X1 34 31 3 XL1 BBCOR 2013 Composite Baseball Bat
Used Easton BB13X1 34 31 3 XL1 BBCOR 2013 Composite Baseball Bat
$175.00
New Rip It Prototype Air B1303A 31 28 BBCOR Baseball Bat 2013 Baseball 2013
New Rip It Prototype Air B1303A 31 28 BBCOR Baseball Bat 2013 Baseball 2013
$74.95
DeMarini 2013 CF5 WTDXCFC Adult Baseball Bat 34 31oz  3
DeMarini 2013 CF5 WTDXCFC Adult Baseball Bat 34 31oz 3
$299.95
2013 EASTON XL1 BB13X1 34 31 BBCOR BASEBALL BAT OUTSTANDING CONDITION SEE PICS
2013 EASTON XL1 BB13X1 34 31 BBCOR BASEBALL BAT OUTSTANDING CONDITION SEE PICS
$299.99
New Easton XL2 BB13X2 34 31 BBCOR Baseball Bat 2 5 8 Yellow Black 2013  3 NIW
New Easton XL2 BB13X2 34 31 BBCOR Baseball Bat 2 5 8 Yellow Black 2013 3 NIW
$119.95
Used Easton BB13X1 34 31 XL1 BBCOR Adult Baseball Bat 3 2013 2 5 8 Ebay
Used Easton BB13X1 34 31 XL1 BBCOR Adult Baseball Bat 3 2013 2 5 8 Ebay
$159.95
New Easton XL3 34 31 BB13X3 BBCOR Baseball Bat Yellow Black 2013 2 5 8 3
New Easton XL3 34 31 BB13X3 BBCOR Baseball Bat Yellow Black 2013 2 5 8 3
$149.95
New Demarini VNC13 Vexxum 34 31 BBCOR Baseball Bat Orange White Gray 2013
New Demarini VNC13 Vexxum 34 31 BBCOR Baseball Bat Orange White Gray 2013
$79.95
Easton XL3 Power Brigade Bbcor 34 31 Baseball Bat  3 2013 W Knobcuff EZ Taper
Easton XL3 Power Brigade Bbcor 34 31 Baseball Bat 3 2013 W Knobcuff EZ Taper
$54.00
Used Demarini VDC13 Voodoo 34 31 BBCOR Baseball Bat 3 2013 Composite
Used Demarini VDC13 Voodoo 34 31 BBCOR Baseball Bat 3 2013 Composite
$159.95
Demarini Voodoo Overlord Baseball Bat 31 Inch 18 Ounce 13 USSSA 115 BPF 2013
Demarini Voodoo Overlord Baseball Bat 31 Inch 18 Ounce 13 USSSA 115 BPF 2013
$79.99
Used Easton XL1 34 31 BB13X1 BBCOR Baseball Bat Black Yellow 3 2013 2 5 8
Used Easton XL1 34 31 BB13X1 BBCOR Baseball Bat Black Yellow 3 2013 2 5 8
$149.00


Recently Purchased 2013 31:


demarini voodoo overlord baseball bat 31 inch 18 ounce 13 usssa 115 bpf 2013, used demarini vdc13 voodoo 3431 bbcor baseball bat 3 2013 composite, easton xl3 power brigade bbcor 3431 baseball bat 3 2013 w knobcuff ez taper, new demarini vnc13 vexxum 3431 bbcor baseball bat orangewhitegray 2013, new easton xl3 3431 bb13x3 bbcor baseball bat yellowblack 2013 2 58 3, new easton xl2 bb13x2 3431 bbcor baseball bat 2 58 yellowblack 2013 3 niw, 2013 easton xl1 bb13x1 34 31 bbcor baseball bat outstanding condition see pics, used easton bb13x1 3431 3 xl1 bbcor 2013 composite baseball bat, used easton bb13x1 3431 xl1 bbcor adult baseball bat 3 2013 2 58 ebay, used easton xl1 3431 bb13x1 bbcor baseball bat blackyellow 3 2013 2 58, new ripit prototype air b1303a 3128 bbcor baseball bat 2013 baseball 2013, demarini 2013 cf5 wtdxcfc adult baseball bat 3431oz 3



Comments are closed.