Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Function
Is it possible to to select row 1 in a spreadsheet and put the workday date
in each column w/o typing in each date individually? Thanks, Del Dobbs |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Function
Hi
One way Enter 04/01/2010 in cell A1 in B1 enter =IF(WEEKDAY(A1,2)=5,A1+3,A1+1) and copy across as far as required -- Regards Roger Govier "DUNNER7" wrote in message ... Is it possible to to select row 1 in a spreadsheet and put the workday date in each column w/o typing in each date individually? Thanks, Del Dobbs __________ 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
|
|||
|
|||
Date Function
Hi,
You could do it with a macro but how about this instead. Put your first date in A1 then the formula in b1 =WORKDAY(A1,1) Drag right If you get a NAME error then Tools|addins and check the analysys toolpak or without the ATP put this in b1 and drag right =A1+1+CHOOSE(WEEKDAY(A1+1,2),0,0,0,0,0,2,1) Mike "DUNNER7" wrote: Is it possible to to select row 1 in a spreadsheet and put the workday date in each column w/o typing in each date individually? Thanks, Del Dobbs |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
Difference System date and Excel Date function | Excel Worksheet Functions | |||
Date function in ACCRINTM requires date format not available | Excel Worksheet Functions | |||
Date Function formula that will return the date of a specific week | Excel Worksheet Functions | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions |