How to track expenses to identify variances 💰 #4

[@MoneywithDan]

You can buy my Excel Template that I use in this video at my online store here: www.etsy.com/au/shop/MoneyWithDan In the template, I also have a dedicated page for frequently asked questions and my answers (FAQs). I also include an alternative Data tab for bank downloads with two columns!

[@blackbluelover]

Thank you so much! Very useful and helpful info

[@MoneywithDan]

Thanks for watching!

[@WoutG]

Oi Dan ! Thenks alot men for your Australien explenetien ! :) Got my exprenses up and running.

[@MoneywithDan]

No worries mate! Glad it helped!

[@karl1469]

Presentation is as impressive as the content is useful. TY

[@MoneywithDan]

Thank you so much!

[@mariacar2321]

Very helpful

[@MoneywithDan]

Why thank you 😁

[@thomass4773]

Hmmm, doesn't work for me. Every time I try adding the =month(cell) or =year(cell) I get the error #VALUE!.... Maybe I'm using a more recent version of Excel and it has some differences?

[@MoneywithDan]

That is strange. Have you formatted the cells with dates or is it formatted as numbers m? The version of excel should not impact this formula.

[@thomass4773]

@@MoneywithDan No formatting was done to the CSV sheet other than opening it in Excel and saving it as an XLSX file. I checked the cells with the dates and they are all formatted as "General". The entire DATA tab/sheet is. I agree it is weird. I've looked all over online to find a possible cause, and none of the suggestions have worked.

[@MoneywithDan]

@ you said the cells with dates are formatted as general… they should be formatted as dates

[@thomass4773]

@@MoneywithDan Tried switching, but it doesn't work. Thanks for trying.