Auto Fill Weekdays

  • Thread starter Horatio J. Bilge, Jr.
  • Start date
H

Horatio J. Bilge, Jr.

On Excel 2008, when I use Auto Fill, and select Fill Weekdays, I get Sunday
through Thursday, instead of Monday through Friday.

Here's what I'm doing:
* In A1, type Monday.
* Grab the handle on the bottom-right of A1, and drag down.
* Excel Auto Fills with Sunday through Saturday (all 7 days).
* I click on Auto Fill Options, and select "Fill Weekdays."
* Excel Auto Fills with Sunday through Thursday (not Monday through Friday)

Any ideas how to fix this?
Thanks,
~ Horatio
 
B

Bob Greenblatt

On Excel 2008, when I use Auto Fill, and select Fill Weekdays, I get Sunday
through Thursday, instead of Monday through Friday.

Here's what I'm doing:
* In A1, type Monday.
* Grab the handle on the bottom-right of A1, and drag down.
* Excel Auto Fills with Sunday through Saturday (all 7 days).
* I click on Auto Fill Options, and select "Fill Weekdays."
* Excel Auto Fills with Sunday through Thursday (not Monday through Friday)

Any ideas how to fix this?
Thanks,
~ Horatio
No Idea how to fix this. It looks like a bug to me.
 
C

CyberTaz

I know it seems like it 'should' work for day names but it only works for
actual Dates. It's based on the serial date values & the day names don't
qualify ‹ they're text strings. For what you want you might try:

Start with Monday & just drag to complete the rest of the week through
Friday. If you need more than the one week copy those 5 cells, paste to the
next group of 5 cells. If you need more than that, select the 10 cells then
use the Fill Handle to extend from there.

If this is something you need to do repeatedly go into Excel> Preferences>
Custom Lists. Create your own list to include only Monday-Friday. Excel will
observe that as the default when you use the Fill Handle. The downside is
that it won't give you the full 7 days unless you start a new list on the
sheet with Saturday or Sunday.

HTH |:>)
Bob Jones
[MVP] Office:Mac
 
H

Horatio J. Bilge, Jr.

Thanks for the reply. I tried it out with actual dates, and it worked just
fine.
Out of curiosity, I tried my original technique in Excel2007, and it worked
as expected there. So it must be a difference in Mac vs. PC versions.

~ Horatio
 
C

CyberTaz

Yeah, I just confirmed your findings in 2007 & 2003 as well as in Mac Excel
2004, but I can't for the life of me figure why it's different unless 2008
just plain broke it 8>} Apparently I was misinformed on how the feature
works & I really don't use it very much.

On the same line, OS X provides an option for setting a preferred starting
day of the week, but changing that from Sunday to Monday has no impact on
Excel's fill even after a system restart. Since it appears to work as you
expect everywhere but in 2008 we'll call it a bug & run it up the pole.

Thanks for the confirmation.

Regards |:>)
Bob Jones
[MVP] Office:Mac
 
H

Horatio J. Bilge, Jr.

Thanks for the information.

CyberTaz said:
Yeah, I just confirmed your findings in 2007 & 2003 as well as in Mac Excel
2004, but I can't for the life of me figure why it's different unless 2008
just plain broke it 8>} Apparently I was misinformed on how the feature
works & I really don't use it very much.

On the same line, OS X provides an option for setting a preferred starting
day of the week, but changing that from Sunday to Monday has no impact on
Excel's fill even after a system restart. Since it appears to work as you
expect everywhere but in 2008 we'll call it a bug & run it up the pole.

Thanks for the confirmation.

Regards |:>)
Bob Jones
[MVP] Office:Mac





.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top