Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is it possible to grab just the Mondays-Thursdays of every month?
I am creating a spreadsheet to keep track of dentist office productivity. In
one box, I want to allow the user to enter the month and have the workdates change accordingly. For example, our office works Mondays through Thursdays. In 2005, the first Monday in January is the 3rd. How could I change the dates to read 3, 4, 5, 6, then skip to 10, 11, 12, 13, then skip until all the M-Th of the month are included. These dates should change if the user types in a different month. Thank you for your help. Arlen |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table - Group by Month - Show Items with no data | Excel Discussion (Misc queries) |