up vote 2 down vote favorite
share [g+] share [fb]

I have an excel sheet, in which I filled the date 01/03/2013.

I used the autofill feature to fill in the weekdays only, but excel filled Sunday to Friday, instead of Sunday to Thursday.

Any way to change that?

link|improve this question
Should it fill Monday to Friday? – harper89 Feb 16 at 13:05
1  
No, Sunday to Thursday - that's the work week in Israel. – jbkkd Feb 16 at 13:43
1  
Would you like a macro where you put in the first date and it fills in the date plus 4, skips 2, fills 5, etc? – Raystafarian Feb 16 at 13:44
@jbkkd ahh i see, well lets just fill Monday - Tuesday..now thats a workweek. – harper89 Feb 16 at 13:52
feedback

2 Answers

up vote 5 down vote accepted

Go to the developer tab (file - options - customize ribbon - check developer tab on the right) and addins - Analysis toolpack Once you do this, type in your first date (A1 for instance) as a Sunday below that use the formula =workday.intl(A1,1,7) and drag it down. It will give you Sunday through Thursday. more info on workday function

edit - I think for 2010 it's included as a regular function.

link|improve this answer
2  
+1 FYI WORKDAY.INTL is only available in Excel 2010 - it isn't part of Analysis ToolPak - in earlier versions you can do the same by manipulating WORKDAY, i.e. =WORKDAY(A1+1,1)-1 - Note WORKDAY is part of Analysis ToolPak in Excel 2003 and earlier, in 2007 and later it's built-in – barry houdini Feb 16 at 14:22
@barryhoudini Good info, thanks. I had never used workday.intl before, but it seems pretty useful – Raystafarian Feb 16 at 14:24
Worked like a charm. Thanks! – jbkkd Feb 16 at 15:42
feedback
up vote 0 down vote

This sounds like a problem with Windows regional settings. Excel should get the information on weekdays from there. Check if Regional settings in Control Panel is set to use standards for Israel.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown
discard

Not the answer you're looking for? Browse other questions tagged or ask your own question.