#NAME? error

%3CLINGO-SUB%20id%3D%22lingo-sub-2539216%22%20slang%3D%22en-US%22%3E%23NAME%3F%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2539216%22%20slang%3D%22en-US%22%3E%3CP%3E%3CU%3ECan%20someone%20help%20with%20the%20%23NAME%3F%20error%3F%20I%20cannot%20find%20the%20error%20in%20my%20formula%2Fsyntax%20and%20need%20help.%20I%20have%20this%20on%20a%20calendar%26nbsp%3Bexcel%20template%20and%20need%20the%20days%20of%20the%20month%20in%20the%20tops%20of%20the%20boxes.%20Here%20is%20the%20formula%20giving%20the%20error%20%3A%26nbsp%3B%3DDaysAndWeeks%2BDATE(CalendarYear%2C1%2C1)-WEEKDAY(DATE(CalendarYear%2C1%2C1)%2C(WeekStart%3D%22Monday%22)%2B1)%2B1%3C%2FU%3E%3C%2FP%3E%3CP%3E%3CU%3EThis%20formula%20has%20worked%20previously%20in%20this%20same%20calendar%2C%20but%20this%20error%20happened%20after%20downloading%20it%20again%20from%20google%20drive.%20Thank%20you%20for%20the%20help%20in%20advance.%3C%2FU%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2539216%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2539321%22%20slang%3D%22en-US%22%3ERe%3A%20%23NAME%3F%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2539321%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1101551%22%20target%3D%22_blank%22%3E%40alysonpetersen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIs%20it%20possible%20to%20share%20copy%20of%20the%20file%20removing%20sensitive%20information%20from%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2539379%22%20slang%3D%22en-US%22%3ERe%3A%20%23NAME%3F%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2539379%22%20slang%3D%22en-US%22%3EI%20guess%20you%20lost%20your%20named%20range%20DaysAndWeeks%E2%80%A6%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2539417%22%20slang%3D%22en-US%22%3ERe%3A%20%23NAME%3F%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2539417%22%20slang%3D%22en-US%22%3EHow%20would%20I%20reenter%20the%20range%3F%20I%20tried%20retyping%20it%20but%20got%20the%20same%20error%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2539458%22%20slang%3D%22en-US%22%3ERe%3A%20%23NAME%3F%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2539458%22%20slang%3D%22en-US%22%3EJust%20uploaded%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2539459%22%20slang%3D%22en-US%22%3ERe%3A%20%23NAME%3F%20error%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2539459%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1101551%22%20target%3D%22_blank%22%3E%40alysonpetersen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E1)%20Ribbon%20%22Formulas%22%3CBR%20%2F%3E2)%20Name%20Manager%3C%2FP%3E%3CP%3E3)%20Search%20the%20Name%3C%2FP%3E%3CP%3E4)%20Set%20correct%20Range%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22German_Chris_0-1626111959200.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F295076i3D8DFB106FB75D17%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22German_Chris_0-1626111959200.png%22%20alt%3D%22German_Chris_0-1626111959200.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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?