G Guest Nov 1, 2005 #1 What is the best way to calculate the week ending date from a given transaction date?
P Peo Sjoblom Nov 1, 2005 #2 It depends on when your week ends and start, do you mean Friday, Saturday or Sunday? -- Regards, Peo Sjoblom "(e-mail address removed)"
It depends on when your week ends and start, do you mean Friday, Saturday or Sunday? -- Regards, Peo Sjoblom "(e-mail address removed)"
G Guest Nov 1, 2005 #3 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 "(e-mail address removed)" Click to expand...
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 "(e-mail address removed)" Click to expand...
P Peo Sjoblom Nov 1, 2005 #4 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 "(e-mail address removed)"
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 "(e-mail address removed)"
