Mar 29 2024 03:08 PM - edited Mar 29 2024 03:46 PM
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
Mar 29 2024 03:48 PM
Mar 29 2024 03:58 PM