Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Desire Weekday returned in every 5th Cell
I have a worksheet with Monday, March 15, 2010 in Cell A2.
I'd like to have a formula that will put Tuesday, March 16, 2010 in the fifth cell after that (in this case Cell A7) and so on......I do not want Saturdays/Sundays to show up. Any idea if this can be done and if so, with what formula? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Desire Weekday returned in every 5th Cell
On Sun, 21 Feb 2010 09:46:01 -0800, MMangen
wrote: I have a worksheet with Monday, March 15, 2010 in Cell A2. I'd like to have a formula that will put Tuesday, March 16, 2010 in the fifth cell after that (in this case Cell A7) and so on......I do not want Saturdays/Sundays to show up. Any idea if this can be done and if so, with what formula? Assuming that it is acceptable to have the cells in A column that not have any date as blank cells, try this formula in cell A3: =IF(MOD(ROWS(A$2:A2),5),"",WORKDAY(A$2,ROWS(A$3:A3 )/5)) copy down as far as needed. The content of cell A2 has to be a number that is formatted as you describe, it can't be text. Make sure that you format all other cells in column A to get the date format you want. Use custom cell format for that. Hope this helps / Lars-Åke |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
AutoShape Desire(s) | Excel Discussion (Misc queries) | |||
Weekday + Time Calculation in Cell | Excel Worksheet Functions | |||
WEEKDAY() function: display TEXT not numeric weekday | Excel Discussion (Misc queries) | |||
Desire Sum to add visible figures rather than underlying decimals | Excel Discussion (Misc queries) | |||
A simple listing desire... | Excel Worksheet Functions |