#NAME? error

Copper Contributor

Can someone help with the #NAME? error? I cannot find the error in my formula/syntax and need help. I have this on a calendar excel template and need the days of the month in the tops of the boxes. Here is the formula giving the error : =DaysAndWeeks+DATE(CalendarYear,1,1)-WEEKDAY(DATE(CalendarYear,1,1),(WeekStart="Monday")+1)+1

This formula has worked previously in this same calendar, but this error happened after downloading it again from google drive. Thank you for the help in advance.

7 Replies

@alysonpetersen 

Is it possible to share copy of the file removing sensitive information from it?

I guess you lost your named range DaysAndWeeks…
How would I reenter the range? I tried retyping it but got the same error
Just uploaded

@alysonpetersen 

 

1) Ribbon "Formulas"
2) Name Manager

3) Search the Name

4) Set correct Range

 

German_Chris_0-1626111959200.png

 

I am on a Mac, what would be the option instead of names manager?