| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Bob
Many thanks this works really, really well!!!!! "Bob Phillips" wrote: Assuming the date is in A1, and the week starts on a Monday, then =A1+CHOOSE(WEEKDAY(A1),1,0,-1,-2,-3,-4,-5) -- HTH RP (remove nothere from the email address if mailing direct) "Peter W" wrote in message ... I have previously been using weeknum function to produce reports in week number order. Users now wish to see the actual start date of each week. Is there a standard function to do this or do I need to create an algorithm? Regards |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dates by week, formula | 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 | |||
| How do I ensure dates inputted are during the work week? | Excel Worksheet Functions | |||
Hybrid Mode
