| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Find last day of month depending on criteria
Range A1:JA1 has all our work days for the year (holidays and weekends are
excluded). In P32 I want to enter the number of a month (i.e. 1 = Jan, 2 = Feb, etc.) and have a formula in Q32 that looks in A1:JA1 and returns the largest date for the month I entered in P32. Thank you, Jeff |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Please help - subtotal using vlookup depending on variable month | Excel Discussion (Misc queries) | |||
| Conditional SUM of column values depending on the heading (month) | Excel Discussion (Misc queries) | |||
| Populate, Depending on Criteria | Excel Discussion (Misc queries) | |||
| How do I add totals from a range of dates depending on the month? | Excel Worksheet Functions | |||
| Display number of day of month depending on the year | Excel Discussion (Misc queries) | |||
Threaded Mode
