The formula for getting the First day (Monday) of the First Week of the Current Year #inSalesforce
CASE(WEEKDAY(DATE(YEAR(TODAY()), 1, 1)),
1, DATE(YEAR(TODAY()), 1, 1) + 1,
2, DATE(YEAR(TODAY()), 1, 1),
3, DATE(YEAR(TODAY()), 1, 1) - 1,
4, DATE(YEAR(TODAY()), 1, 1) - 2,
5, DATE(YEAR(TODAY()), 1, 1) - 3,
6, DATE(YEAR(TODAY()), 1, 1) - 4,
DATE(YEAR(TODAY()), 1, 1) - 5)
First Monday of every quarter
DATE(
YEAR(TODAY() ),
CASE(MONTH( TODAY()),
01,01,
02,01,
03,01,
04,04,
05,04,
06,04,
07,07,
08,07,
09,07,
10),
CASE(MOD(
DATE(
YEAR(TODAY()),
CASE(MONTH( TODAY()),
01,01,
02,01,
03,01,
04,04,
05,04,
06,04,
07,07,
08,07,
09,07,
10),
01) - DATE(1900, 1, 7), 7),
0, 2,
1, 1,
2, 7,
3, 6,
4, 5,
5, 4,
6, 3,
0)
)
1, DATE(YEAR(TODAY()), 1, 1) + 1,
2, DATE(YEAR(TODAY()), 1, 1),
3, DATE(YEAR(TODAY()), 1, 1) - 1,
4, DATE(YEAR(TODAY()), 1, 1) - 2,
5, DATE(YEAR(TODAY()), 1, 1) - 3,
6, DATE(YEAR(TODAY()), 1, 1) - 4,
DATE(YEAR(TODAY()), 1, 1) - 5)
First Monday of every quarter
DATE(
YEAR(TODAY() ),
CASE(MONTH( TODAY()),
01,01,
02,01,
03,01,
04,04,
05,04,
06,04,
07,07,
08,07,
09,07,
10),
CASE(MOD(
DATE(
YEAR(TODAY()),
CASE(MONTH( TODAY()),
01,01,
02,01,
03,01,
04,04,
05,04,
06,04,
07,07,
08,07,
09,07,
10),
01) - DATE(1900, 1, 7), 7),
0, 2,
1, 1,
2, 7,
3, 6,
4, 5,
5, 4,
6, 3,
0)
)
Comments
Post a Comment