Forum Discussion
Help with an Excel Formula
Hi Den,
It shall be some name, please check in Name Manager (Formulas tab in ribbon)
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.
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}*7please 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
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?