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