Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy question (just not for me)
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy question (just not for me)
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Easy question (just not for me)
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Easy question | Excel Discussion (Misc queries) | |||
Easy question | Excel Discussion (Misc queries) | |||
Easy question for you all | Excel Worksheet Functions | |||
new user with easy question? not easy for me | New Users to Excel | |||
easy question .... i think | Excel Discussion (Misc queries) |