K
kevin.raway
What is the best way to calculate the week ending date from a given
transaction date?
transaction date?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
Peo Sjoblom
It depends on when your week ends and start, do you mean Friday,
Saturday or Sunday?
--
Regards,
Peo Sjoblom
"[email protected]"
Saturday or Sunday?
--
Regards,
Peo Sjoblom
"[email protected]"
K
kevin.raway
Saturday. But why does it matter?
Peo Sjoblom said:It depends on when your week ends and start, do you mean Friday,
Saturday or Sunday?
--
Regards,
Peo Sjoblom
"[email protected]"
P
Peo Sjoblom
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
"[email protected]"
=A1+7-WEEKDAY(A1)
and of course it matters what day of the week you are looking for
--
Regards,
Peo Sjoblom
"[email protected]"