Forum Discussion
Solved
Excel Template: Any Year Expense Calendar
I've downloaded from my Microsoft Excel desktop app the template Any Year Expense Calendar. I'm planning to add rows for my expenses and because I'm not very familiar with date formulas and decided to turn on Show Formulas. I realized that some of the formulas where "hidden" in the weekdays of the template, so I unmerged the cells and noticed that there is a section of the formula that has #REF! Isn't this an error meaning that it can't find the cell it wants to reference? Did I create it by unmerging the cells or is it something else? I'm not sure how to post the location of the template, as I could not locate it on Microsoft's website of templates.
Here is the formula:
=IF(WEEKDAY(DATEVALUE(Month1&" 1, "&@Year1))=COLUMN(#REF!),1,IF(LEN(C5)>0,C5+1,""))
Thank you.
Perhaps this one Any Year Expense Calendar Excel Template (visual-paradigm.com) ?
Yes, most probably an error is since you changed document structure with unmerging.
Perhaps this one Any Year Expense Calendar Excel Template (visual-paradigm.com) ?
Yes, most probably an error is since you changed document structure with unmerging.
