| Home |
| Search |
| Today's Posts |
|
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date Question
On 4 Jul, 16:19, "Rick Rothstein \(MVP - VB\)"
wrote: If A1 contains any date within the month, then the first Monday of that month can be found with this formula.... =A1-DAY(A1)+1+CHOOSE(WEEKDAY(A1-DAY(A1)+1),1,0,6,5,4,3,2) Rick "AMaleThing" wrote in message ... Is there a forumla to enter into a cell which can report for e.g. a) the date of the first monday of the month? b) the first working day of the week? Much appreciated.- Hide quoted text - - Show quoted text - Starting with the simpiest looking formulas, I'm trying: =A1+MOD(8-WEEKDAY(A1,2),7) Can you help me to understand why 8 is subtracted from WEEKDAY? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DATE question | Excel Worksheet Functions | |||
| Date Question | Excel Discussion (Misc queries) | |||
| Date question | Excel Worksheet Functions | |||
| This is a date question... | Excel Discussion (Misc queries) | |||
| date question | Excel Programming | |||
Threaded Mode
