series of dates, step by 1, Mon-Thurs only, for 2007

  • Thread starter Thread starter Lisa Hetherington
  • Start date Start date
L

Lisa Hetherington

I would like to have all the dates I'm going to work from Jan 29/07 to Dec
31/07, leaving out all Fri, Sat and Sun dates.

I'm not sure how to do this.

Can someone help me please??
Thanks!!

....Lisa, using Excel 2003
 
Lisa Hetherington said:
I would like to have all the dates I'm going to work from Jan 29/07 to Dec
31/07, leaving out all Fri, Sat and Sun dates.
Click to expand...
....

Enter Jan 29 in cell A1, enter the following formula in A2,

=A1+IF(WEEKDAY(A1,2)=4,4,1)

and fill A2 down as far as needed.
 
Perfect!!
Thank you.

....Lisa
Harlan Grove said:
...

Enter Jan 29 in cell A1, enter the following formula in A2,

=A1+IF(WEEKDAY(A1,2)=4,4,1)

and fill A2 down as far as needed.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help to Highlight Excel Row based on Weekly Date Range 2
Adding days to the WORKDAY function 1
Count only Mon-Thurs? 14
Which function will work best? And how do I set it up? 0
sort a column by date- by month not year 5
NETWORKDAYS XL2007 problem with calculating Banking Days in a mont 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Trendline Showing Problem ? 2

Back
Top