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" wrote in message
...
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