Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Week ending
What is the best way to calculate the week ending date from a given
transaction date? |
#2
|
|||
|
|||
Week ending
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? |
#3
|
|||
|
|||
Week ending
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? |
#4
|
|||
|
|||
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 |