Confusicous wrote:
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