The formula for getting the First day (Monday) of the First Week of the Current Year #inSalesforce

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) 
)


Comments