| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
Week ending
With the date in A1 this will return the next Saturday
=A1+7-WEEKDAY(A1) and of course it matters what day of the week you are looking for -- Regards, Peo Sjoblom " m wrote in message ... Saturday. But why does it matter? "Peo Sjoblom" wrote: It depends on when your week ends and start, do you mean Friday, Saturday or Sunday? -- Regards, Peo Sjoblom " m wrote in message ... What is the best way to calculate the week ending date from a given transaction date? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
| user defined function | 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 | |||
Hybrid Mode
