A Better Approach to Financial Year Formulas in Google Sheets
Learn how to get the Financial Year of a Date or range of dates in Google Sheets and display it in a number of formats.
To the Starter Sheet!: https://docs.google.com/spreadsheets/...
00:00 What we're building
01:52 Standard approach
04:24 Financial years that don't start on the 1st of the month
07:31 Apply it to a range
10:18 Show start year and end year
13:03 Show last 2 digits of end year
14:10 Show full financial year date range
If you just want to use a simple function called YEAR_FINANCIAL() in Google Sheets, you should check out my Named Function pack!
https://yagisanatode.com/products/nam...
** My Site **
https://yagisanatode.com/
** More on Google Sheets **
https://yagisanatode.com/google-sheets/
** The Named Functions Pack **
https://yagisanatode.com/products/nam...
Courses *
https://yagisanatode.com/products-cat...
Google Workspace Tools *
https://yagisanatode.com/products-cat...
Google Workspace Add-ons *
https://yagisanatode.com/products-cat...
#GoogleSheets #googleworkspace #spreadsheets #businessadministration #admin #businessmanagement #financialyear
Смотрите видео A Better Approach to Financial Year Formulas in Google Sheets онлайн, длительностью часов минут секунд в хорошем качестве, которое загружено на канал Yagisanatode -Scott- 01 Июль 2024. Делитесь ссылкой на видео в социальных сетях, чтобы ваши подписчики и друзья так же посмотрели это видео. Данный видеоклип посмотрели 567 раз и оно понравилось 8 посетителям.
