Help with an Excel Formula

[Den Hewitt]

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 name or a macro.

[#2]

Hi Den,

It shall be some name, please check in Name Manager (Formulas tab in ribbon)

[#3]

The name does appear where you said, but it does not appear anywhere in any sheet in the workbook.  I think I need to find someone that I can send the workbook to, for them to look at it.

The workbook works in Excel 2007 on my laptop but I downloaded the workbook to Google Sheets and Google Sheets does not like this formula {=DaysAndWeeks+DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1),(WeekStart="Mo")+1)+1}. There is no hidden sheet nor are there any hidden rows or columns in the workbook.

[#4]

Den, if the name is in Name Manager you may see in it what the name means. Anyway, it looks like that's known template https://www.reddit.com/r/excel/comments/309p9p/changing_calendar_days_but_keeping_the_data/ and https://www.mrexcel.com/forum/excel-questions/948251-calendar.html,

could you attach the template to your post here?

[#5]

I didn't find the template, but that's just array constant

DaysAndWeeks={0,1,2,3,4,5,6} + {0;1;2;3;4;5}*7 

please see that post https://www.reddit.com/r/excel/comments/1rwxg0/need_some_help_with_an_array_formula_please/

Thus it won't appear within the sheet, just a constant

[#6]

@Den Hewitt 
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)