Formula for MONDAY START on Any Year Calender Template

Copper Contributor

 

Hello..

 

Please kindly advise how to change formula to Monday Start? 

 

=DAY(IF(DAY(@JanSun1)=1,@JanSun1-6,@JanSun1+1))  -  Original Formula 

=DAY(IF(DAY(@JanMon1)=2,@JanMon1-6,@JanMon1+1)) -  Returned #NAME error

 

Any year expense calendar1.xlsx

 

KM

2 Replies

@KMcSloy 

See the attached version.

I changed the definition of JanSun1, JanSun2 etc.

Wow.. you make it look so easy! Thankyou for your help & quick response. Greatly Appreciated!!