Forum Discussion
Help 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 name or a macro.
5 Replies
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
