| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Skip a day of the week
Hi Darbar: This is the best I could come up with; I hope its good enough. =IF(A2+WEEKDAY(A1,1)=5,A2+A1+1,A2+A1) Or =IF(A2+WEEKDAY(A1)=1,A1+A2,IF(A2+WEEKDAY(A1)=2,A1+ A2,IF(A2+WEEKDAY(A1)=3,A1+A2,IF(A2+WEEKDAY(A1)=4,A 1+A2,IF(A2+WEEKDAY(A1)=5,A1+A2+1,IF(A2+WEEKDAY(A1) =6,A1+A2,IF(A2+WEEKDAY(A1)=12,A1+A2,""))))))) Place either, or in C1. The formulas work like you requested, "skipping over Thursday". Formulas only work for the first Thursday, that means A2 should not be a number greater than 6. Problem is you can't remove Thursday's from the calendar, and the date functions won’t allow you to ignore them either. Or more to the fact is that I just don't have enough know how to get around it. Matt -- Flintstone ------------------------------------------------------------------------ Flintstone's Profile: http://www.excelforum.com/member.php...o&userid=15310 View this thread: http://www.excelforum.com/showthread...hreadid=373356 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| user defined function | Excel Worksheet Functions | |||
| how to get 52 week hi/lo data for UK stocks | Excel Worksheet Functions | |||
| Line or bar graphs for tracking stocks profit and loss. | Charts and Charting in Excel | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
| first week of year - according to european standard | Excel Worksheet Functions | |||
Threaded Mode
