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?
Super User is a question and answer site for computer enthusiasts and power users. It only takes a minute to sign up.Sign up to join this community
Go to the
Once you do this, type in your first date (A1 for instance) as a Sunday
below that use the formula
developer tab (
file - options - customize ribbon - check
developer tab on the right) and
addins - Analysis toolpack
=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.