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?

  • Should it fill Monday to Friday? – sealz Feb 16 '12 at 13:05
  • 1
    No, Sunday to Thursday - that's the work week in Israel. – jbkkd Feb 16 '12 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 '12 at 13:44
  • @jbkkd ahh i see, well lets just fill Monday - Tuesday..now thats a workweek. – sealz Feb 16 '12 at 13:52

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.

| 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 '12 at 14:22
  • @barryhoudini Good info, thanks. I had never used workday.intl before, but it seems pretty useful – Raystafarian Feb 16 '12 at 14:24

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.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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