Easy question (just not for me)

C

Confusicous

I am trying to drag down a date for monday through friday throughout the year:
monday
tuesday
wednesday
thursday
friday
monday
tuesday
ect...
What would be or how would I make it to where it skips the saturday/sunday
dates to go right to the next monday date?
Thanks in advance
 
R

Roger Govier

Hi

With 04/01/2010 in cell A1, enter the folowing formula in A2 and copy down
as required
=IF(WEEKDAY(A1,2)=5,A1+3,A1+1)
--
Regards
Roger Govier

Confusicous said:
I am trying to drag down a date for monday through friday throughout the
year:
monday
tuesday
wednesday
thursday
friday
monday
tuesday
ect...
What would be or how would I make it to where it skips the saturday/sunday
dates to go right to the next monday date?
Thanks in advance

__________ Information from ESET Smart Security, version of virus
signature database 4742 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com

__________ Information from ESET Smart Security, version of virus signature database 4742 (20100104) __________

The message was checked by ESET Smart Security.

http://www.eset.com
 
B

Bill Sharpe

Confusicous said:
I am trying to drag down a date for monday through friday throughout the year:
monday
tuesday
wednesday
thursday
friday
monday
tuesday
ect...
What would be or how would I make it to where it skips the saturday/sunday
dates to go right to the next monday date?
Thanks in advance

Enter Monday through Friday in A1 through A5(or wherever your list starts).
Highlight the five cells, then copy and paste as desired below.

Bill
 

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

Top