| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Dates of a Day for a month & year cell formulas
I've been trying to come up with a cell formula that returns the dates of certain days of a specified month & year depending if Weekly, Bi-Weekly, Monthly, or Semi-Monthly. For example Cell A1 = 2006 Cell B1 = Sunday Cell C1 = Weekly (or could be Bi-weekly, or Monthly, or Semi-monthly) Cell A3 = January Cell A4 = 1-01-06 Cell A5 = 1-08-06 Cell A6 = 1-15-06 Cell A7 = 1-22-06 Cell A8 = 1-29-06 Cell B3 = February Cell B4 = 2-05-06 Cell B5 = 2-12-06 Cell B6 = 2-19-06 Cell B7 = 2-26-06 To prevent the formula from being overly complex, it may be easier to have a separate sheet for weekly, bi-weekly, monthly, & semi-monthly. Please help. Thanks so much. mikeburg -- mikeburg ------------------------------------------------------------------------ mikeburg's Profile: http://www.excelforum.com/member.php...o&userid=24581 View this thread: http://www.excelforum.com/showthread...hreadid=496686 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Counting dates for a the present month but not future months | Excel Worksheet Functions | |||
| Am I able to sort dates by month rather than year in excel? | Excel Discussion (Misc queries) | |||
| Formulas within Cell References | Excel Discussion (Misc queries) | |||
| GET.CELL | Excel Worksheet Functions | |||
Threaded Mode
