ThisCalculator

Date and time

Date Calculator QLD: How to Count Days in Queensland

Updated · Standard formula, shown below

The calculator for this page is switched off while it is checked. The formula is below, and the worked example in the article shows how to use it by hand.

Date Calculator QLD: How to Count Days in Queensland

The Date Calculator QLD works out the number of days between two dates, or the date that falls a set number of days before or after a given date, using the standard Gregorian calendar. You enter a start date and either an end date or a number of days, and the calculator returns the exact day count or the resulting date. This page explains how the calculation works, what to watch out for in Queensland, and how to get accurate results for legal, personal, or business deadlines.

Formula

The core formula is simple subtraction of calendar dates. Each date is converted to a serial day number (the number of days since a fixed epoch, such as 1 January 1900). The difference between the two serial numbers gives the number of days between them.

In mathematical terms: Days = Serial(end date) – Serial(start date)

Where:

  • Start date – the earlier date (format YYYY-MM-DD)
  • End date – the later date (format YYYY-MM-DD)
  • Days – the number of full 24-hour periods between the two dates, exclusive of the start date and inclusive of the end date

This is the standard method used by most date calculators and spreadsheet functions like Excel’s DATEDIF or DAYS.

Worked Example

Using the default values in the calculator above:

  1. Start date: 1 January 2025
  2. End date: 31 December 2025
  3. Serial difference: 31 December 2025 minus 1 January 2025
  4. Days = 364 (because 2025 is not a leap year; there are 365 days in the year, but the difference between Jan 1 and Dec 31 is 364 days)

The calculator shows 364 days between those dates. Note that if you count both the start and end dates, the total is 365 days – but the calculator counts the number of days between, which is the standard for date arithmetic.

Why Queensland-specific Date Calculations Matter

Queensland follows the same Gregorian calendar as the rest of Australia, so the basic day count is identical. However, Queensland-specific contexts can affect how you interpret the result:

  • Public holidays – Queensland has its own public holidays (e.g., Ekka Wednesday in Brisbane, Queen’s Birthday in October). If you’re calculating working days, you’ll need to exclude these.
  • Legal deadlines – Queensland courts and tribunals often count days in a specific way. For example, the Acts Interpretation Act 1954 (Qld) sets rules for how time is computed in legislation. Generally, if a period is expressed in days, you exclude the first day and include the last, unless the last day falls on a weekend or public holiday, in which case it moves to the next business day.
  • School terms – Queensland school term dates vary each year, so a date calculator helps plan holidays or enrolments.

Always check the specific rules of the contract, law, or policy you’re dealing with, because some documents define “daysâ€� as calendar days, others as business days, and others as “clear daysâ€� (which exclude the first and last day).

How to Use the Calculator for Different Purposes

This calculator is flexible. You can use it for:

  • Counting days between two dates – e.g., “How many days from 1 March to 30 April?â€�
  • Finding a date after a certain number of days – e.g., “What is 90 days from today?â€� (though this calculator currently only does the between calculation, you can reverse it by setting the start date and adding days manually)
  • Checking lease terms – e.g., a 6-month lease from 15 January ends on 14 July, not 15 July, because the end date is the day before the same day in the next month.
  • Project planning – e.g., if a task starts on Monday and takes 10 business days, when does it finish? (You’ll need to skip weekends and Queensland public holidays.)

For future date calculations, simply enter today’s date as the start and the target number of days as the difference – but note that this calculator only shows the difference, not the resulting date. For that, you’d need a separate “add daysâ€� calculator.

Common Mistakes and Misconceptions

People often make these errors when counting dates:

  • Including both start and end dates – If you count both, you get one extra day. For example, from Monday to Wednesday is 2 days between, but 3 days if you count Monday as day 1.
  • Ignoring leap years – February 29 adds a day. The calculator automatically handles leap years, but manual counts often miss them.
  • Assuming “daysâ€� means business days – Unless specified, a date calculator counts calendar days. For business days, you must exclude weekends and Queensland public holidays.
  • Using UTC vs local time – If you calculate across a daylight saving change (Queensland does not observe daylight saving, but other states do), the time difference can affect the count if you’re using timestamps. This calculator uses dates only, so it’s immune to that issue.

Limitations of the Formula

The simple subtraction formula works perfectly for calendar days, but it has limits:

  • It does not account for time zones or daylight saving offsets – but since Queensland doesn’t have DST, this is rarely an issue.
  • It cannot handle business days, public holidays, or “clear daysâ€� automatically. You must adjust manually.
  • It assumes the Gregorian calendar, which is the standard in Australia and most of the world.
  • For dates before 1582 (when the Gregorian calendar was introduced), the calculation may not match historical records.

For legal or contractual deadlines, always confirm the interpretation with the relevant legislation or a legal professional, because some acts specify different counting rules.

How to Calculate Manually

If you don’t have a calculator, you can count manually using these steps:

  1. Write down the day of the year for each date (e.g., 1 January = day 1, 31 December = day 365 in a non-leap year).
  2. Subtract the earlier day-of-year from the later day-of-year.
  3. If the period spans a year boundary, add 365 (or 366 for a leap year) for each full year in between.

For example, from 15 November 2024 to 15 March 2025:

  • Day of year for 15 Nov 2024 (leap year) = 320
  • Day of year for 15 Mar 2025 = 74
  • Days remaining in 2024 after Nov 15: 366 – 320 = 46 days
  • Add days in 2025 up to Mar 15: 74 days
  • Total = 46 + 74 = 120 days

This matches the calculator’s result.

Frequently Asked Questions

How do I count days between two dates in Queensland?

Use the same method as anywhere else: subtract the earlier date from the later date. The result is the number of full days between them. For example, from 1 July to 31 July is 30 days, because the difference is 30. If you need business days, exclude weekends and Queensland public holidays.

Does Queensland have daylight saving that affects date calculations?

No, Queensland does not observe daylight saving. The state remains on Australian Eastern Standard Time (AEST, UTC+10) all year. This means date calculations are not affected by clock changes, unlike in New South Wales, Victoria, or South Australia.

What is the difference between calendar days and business days?

Calendar days include every day of the week, including weekends and public holidays. Business days are typically Monday to Friday, excluding public holidays. For example, 10 calendar days from a Friday includes two weekends, while 10 business days would be two full working weeks.

How do Queensland legal deadlines count days?

Under the Acts Interpretation Act 1954 (Qld), when a period of days is prescribed, the first day is excluded and the last day is included. If the last day falls on a weekend or public holiday, the deadline extends to the next business day. However, some laws have specific rules, so always check the particular act or regulation.

Can I use this calculator to find a date 90 days from today?

This calculator only shows the number of days between two dates, not the resulting date. To find a date 90 days from today, you would need to add 90 days to today’s date manually or use a dedicated “add daysâ€� calculator. For example, 90 days from 1 January 2025 is 1 April 2025 (because January has 31 days, February has 28, and March has 31).

Why does the calculator show 364 days for a full year?

Because it counts the number of days between two dates, not the number of days in the year. From 1 January to 31 December is 364 days, because you’re not counting the start date. If you count both 1 January and 31 December as full days, you get 365 days.

Related

Formula used
in start | Start date | - | 2025-01-01 | 0
in end | End date | - | 2025-12-31 | 0
out days | Days between | days | end - start | 0
out weeks | Weeks and days | - | floor(days / 7) | 0

Each line is one input (in, sel, list) or one result (out: label, unit, formula, decimals). How the calculators work

Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.