Tag: Google Sheets DATE

A Better Financial Year Formula In Google Sheets

The most common financial year formula for Google Sheets looks a little like this:

=IF(MONTH(A3) < 7, YEAR(A3) - 1, YEAR(A3))

Where:

=IF(MONTH(date) < financial_year_starting_month, YEAR(date) - 1, YEAR(date))

Display the starting financial year of a target date in Google Sheets

In Australia, our financial year starts on the 1 July. So that’s what I’ve used in the example.

Continue reading “A Better Financial Year Formula In Google Sheets”

Google Sheets FILTER function: Dates and Times

If you have landed on this page you may have discovered that dates and times don’t always work as you might expect with the Google Sheets FILTER  function.

In this tutorial, we are going to cover how to use FILTER on dates, times and date and time stamps (DTS).

You can follow through the tutorial in its entirety or use the table of contents below to get directly to what you need.

Continue reading “Google Sheets FILTER function: Dates and Times”