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

  • 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
  • Worked like a charm. Thanks! – jbkkd Feb 16 '12 at 15:42

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.

Your Answer


By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.

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