NAME ERROR help needed

[SecretaryMom]

I am working with the 'Any year expense calendars' template on Google Sheets. I am getting a Name error for JanSun1 in the formula =DAY(IF(DAY(JanSun1)=1,JanSun1-6,JanSun1+1)).

How do I fix this so I can start using the template for my family budget?

 

[jasonb75]

How do I fix this so I can start using the template for my family budget?

You need to use Excel, not Google Sheets. There are a number of defined names that use formulas as the source, this is a feature that is not compatible with Google Sheets.

Even if you were able to fix that issue, there could still be other compatibility problems with a template that is built primarily for Excel.

 

[SecretaryMom]

You need to use Excel, not Google Sheets. There are a number of defined names that use formulas as the source, this is a feature that is not compatible with Google Sheets.

Even if you were able to fix that issue, there could still be other compatibility problems with a template that is built primarily for Excel.

Thank you. I was hoping to use this template because I've used it previously but that was with Excel.