I need three formulas, one to calculate the date of the next Monday following today, one to calculate the date of the next Wednesday following today and one to calculate the day of the next Friday following today.
A search within the Success Community has identified a formula to calculate the next Monday, but I don't understand the formula enough to know how to alter it to calculate the next Wednesday, and the next Friday.
Below is the formula I have located, can anyone explain how I need to alter this to calculate Wednesday and Friday?
Thanks very much in advance
CASE( MOD(TODAY() - DATE(1900, 1, 7), 7),
0, 1,
1, 7,
2, 6,
3, 5,
4, 4,
5, 3,
6, 2, 0)
11 Antworten
Next Monday =
TODAY() +
CASE(
MOD(TODAY() - DATE( 1900, 1, 7 ), 7 ),
0, 8,
1, 7,
2, 6,
3, 5,
4, 4,
5, 3,
6, 2,
0)
Next Wednesday =
Wed
TODAY() +
CASE(
MOD(TODAY() - DATE( 1900, 1, 7 ), 7 ),
0, 10,
1, 9,
2, 8,
3, 7,
4, 6,
5, 5,
6, 4,
0)
Next Friday =
TODAY() +
CASE(
MOD(TODAY() - DATE( 1900, 1, 7 ), 7 ),
0, 12,
1, 11,
2, 10,
3, 9,
4, 8,
5, 7,
6, 6,
0)
