In this podcast episode you will learn how to create a date format on the formula cells to ensure they correctly display the calculated date.

Excel Yourself: How to work with dates and days in excel

The With Interest podcast brings you unrivalled commentary and thought leadership for businesses, accounting and finance professionals. 

Each week, we share expert industry opinions, insights and resources across accounting, public practice, taxation, auditing, finance, strategy, leadership, economic and business-related issues. 

Subscribe today to stay up-to-date with the latest episodes. 

With Interest is presented by CPA Australia, one of the world’s largest accounting bodies, with core services that include education, training, technical support and advocacy.

In 2018, CPA Australia won an Award of Excellence at the 24th Annual Communicator Awards in the category of 'Podcasts - General-Corporation/Business'. 

----------------------------------------------------
CPA Australia publishes three podcasts:

- With Interest
- INTHEBLACK 
- Excel Tips

To find out more about our podcasts, visit https://www.cpaaustralia.com.au/tools-and-resources/podcasts - or search for the shows in your podcast service. To contact the podcast team email us at podcasts@cpaaustralia.com.au.

Business

Investing

Careers

Management & Marketing

Business News

Shopping

News

Join CPA Australia's expert policy team as we dive into Treasurer Jim Chalmers' announcements from last night's Budget unveiling. Learn what these measures could mean for accountants, business owners and finance professionals, and explore the broader implications for the Australian economy. Uncover valuable insights with this comprehensive breakdown of Budget 2024.  Host: Simon Downes, external affairs lead, policy and advocacy, CPA Australia  Guests: Gavan Ord, business investment and international lead, policy and advocacy, CPA Australia, and Elinor Kasapidis, interim chief learning and innovation officer, learning and innovation, CPA Australia.  For further insights, head to  CPA Australia’s Budget 2024 page  for expert and authoritative insights on the latest Federal Budget.   CPA Australia  publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:    With Interest  INTHEBLACK  INTHEBLACK Out Loud  Excel Tips   Search for them in your podcast platform.   You can email the podcast team at  podcasts@cpaaustralia.com.au

Federal Budget 2024: CPA Australia’s expert analysis

Discover the ins and outs of the ATO’s CAL and find solutions to common problems met by businesses and tax agents. Join us as we unravel the complexities of the ATO’s client-to-agent linking process, also known as CAL. Our expert guest also answers questions sent by CPAs to help troubleshoot real-world issues users have met with CAL. Listen now for your ultimate CAL explainer. Host: Gavan Ord, business investment and international lead, policy and advocacy, CPA Australia Guest: Hannah Griffits CPA, from Moore Lewis & Partners, accountants and tax advisors in Toowoomba, Queensland For more information on today’s topic the ATO has guidance for NFPs and bulk client transfers as well as client-to-agent linking steps and client-to-agent linking in online services. CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:   With Interest  INTHEBLACK  INTHEBLACK Out Loud  Excel Tips  Search for them in your podcast platform. You can email the podcast team at podcasts@cpaaustralia.com.au

Need help troubleshooting the ATO’s CAL?

New tax requirements are on the horizon for not-for-profits, and approximately 150,000 NFPs will have to lodge a tax return.  Learn how these new requirements will affect NFPs and why the ATO implemented the changes.  Tune in now to stay informed.  Host: Ram Subramanian, Interim Head of Policy and Advocacy, CPA Australia Guest: Nunzio Giunta FCPA, the Managing Partner and Founder of Giuntabell, a specialist not-for-profit accounting firm. He is also the chair of the CPA Australia Not-For-Profit Committee in Queensland, and a member of the ATO’s Not-for-Profit Stewardship Group. Nunzio also sits on the Australian Accounting Standards Board Not-For-Profit Advisory panel. For further information related to this topic, head online to the ATO and to the Australian Charities And Not-For-Profits Commission.  CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:    With Interest  INTHEBLACK  INTHEBLACK Out Loud  Excel Tips  Search for them in your podcast platform.  You can email the podcast team at podcasts@cpaaustralia.com.au

New tax changes for NFPs: what you need to know

The world of financial reporting, auditing, assurance and tax advice seems far away from a subject like climate change. But the challenge of sustainability reporting, and the requirements that will fall on the accounting profession, are getting closer and closer.  This podcast will deliver insights on the changes set to happen in sustainability reporting obligations. Delve into the expert analysis on how these measures could impact accountants, finance professionals and businesses alike.  Don’t miss out - tune in to stay ahead of the climate reporting curve. Host: Simon Downes, External Affairs Lead, CPA Australia Guest: Patrick Viljoen, ESG Lead, Policy and Advocacy, CPA Australia For further information, head online to read  CPA Australia’s ESG policy submissions.  Other podcasts on  corporate disclosure and  ISSB’s new reporting standards are also available on the CPA Australia platform.  Additionally,  you can find industry feedback on  Australian Sustainability Reporting Standards – Disclosure of Climate-Related Financial Information.  CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:    With Interest  INTHEBLACK  INTHEBLACK Out Loud  Excel Tips  Search for them in your podcast platform.  You can email the podcast team at podcasts@cpaaustralia.com.au

Expert analysis of new changes to climate reporting

CPA Australia's 15th annual Asia-Pacific Small Business Survey reveals extensive data on small business challenges across the region.  This episode dissects the survey’s findings and delves into the issues faced by businesses in 11 diverse markets, including India, Malaysia, Singapore, Indonesia, Mainland China and Hong Kong.  With input from more than 4,200 business owners and senior managers from companies with less than 20 employees, the survey offers invaluable information for you and your organisation.  Tune in now to gain essential insights for your small business. Host: Simon Downes, External Affairs Lead, CPA Australia Guest: Gavan Ord, Senior Manager Business and Investment Policy, CPA Australia Download CPA Australia's  15th annual Asia-Pacific Small Business Survey and discover valuable insights.  CPA Australia publishes four podcasts, providing commentary and thought leadership across business, finance, and accounting:    With Interest  INTHEBLACK  INTHEBLACK Out Loud  Excel Tips  Search for them in your podcast platform.  You can email the podcast team at podcasts@cpaaustralia.com.au

Excel Yourself: How to work with dates and days in excel

Download our free app to listen on your phone