AncienCopper ContributorOct 01, 2018Help with an Excel Formula I have an Excel template that contains the following formula. {=DaysAndWeeks+DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1),(WeekStart="Mo")+1)+1} What is DaysAndWeeks , it is not a range na...Show More
mliaiterCopper ContributorFeb 03, 2022Ancien hi Den,You should create a range name.Try this one:DaysAndWeeks = {0\1\2\3\4\5\6} + {0:1:2:3:4:5}*7 (excel)
