Easy question (just not for me)

[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

 

[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

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

 

[Bill Sharpe]

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