Easy question (just not for me)

  • Thread starter Thread starter Confusicous
  • Start date Start date
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
 
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 
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
Click to expand...

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
 
Back
Top