---
title: "Dates and times in Google Sheets: formulas and formats"
canonical: "https://www.owox.com/blog/articles/dates-and-times-google-sheets"
updated: "2026-10-05"
---

# Dates and times in Google Sheets: how they work, with formulas

Google Sheets stores a date as a whole number and a time as a fraction of a day. This guide explains that model and shows how to combine and split date-time values, insert the current date and time, sort by date, shift time zones and measure durations.

[Google Sheets Tips](/blog/topics/google-sheets-tips) · Updated October 2, 2026 · [Vadym Kramarenko](/team/vadym-kramarenko) · 13 min read

![Dates and times in Google Sheets: how they work, with formulas](https://cdn.owox.ai/www/webflow/69f0df5853bbd0dd76df0184_HOW-DATES-AND-TIMES-WORK-IN-GOOGLE-SHEETS.png/public)

Google Sheets stores every date as a whole number and every time as a fraction of a day. A date with a time is the two added together. Once you know that, most date and time tasks come down to simple arithmetic:

| You need | Formula |
| --- | --- |
| Combine a date and a time | `=B3 + C3` |
| Date from a date-time | `=INT(B3)` |
| Time from a date-time | `=MOD(B3, 1)` |
| Current date and time | `=NOW()` |
| Add 90 minutes | `=B3 + TIME(1, 30, 0)` |
| Shift by a time zone offset, here 5 hours back | `=B3 - 5/24` |
| Time between two date-times | `=C3 - B3`, formatted as a duration |

## How Google Sheets stores dates and times

A date is a serial number: the number of days since December 30, 1899. October 1, 2024 is 45566. A time is the part of a day that has passed: 6:00 AM is 0.25, noon is 0.5, 6:00 PM is 0.75. So 12 hours are 0.5 days, and one hour is 1/24.

The format of a cell decides only how the number is shown. Change the format under **Format > Number** and the same value appears as a date, a time, a date-time or a plain number, while formulas keep working with the number underneath.

### Arithmetic with dates

Because a day is 1, adding a number to a date moves it by that many days:

> `=B3+10`

![Google Sheets with the formula =B3+10 in E3 returning October 11, 2024 for the date October 1, 2024 in B3](https://cdn.owox.ai/www/webflow/678710d2750298f7a4cad674_59859.png/public)

Subtracting one date from another gives the number of days between them:

> `=E3-B3`

![Google Sheets with the formula =E3-B3 in F3 returning 10, the number of days between October 1 and October 11, 2024](https://cdn.owox.ai/www/webflow/678710d34aafb780e1a7cd17_59861.png/public)

### Arithmetic with times

To add hours and minutes, build the amount with the [TIME function](/blog/articles/time-functions-google-sheets):

> `=B3+TIME(1, 30, 0)`

![Google Sheets with the formula =B3+TIME(1, 30, 0) in D3 returning 9:30 AM for the time 8:00 AM in B3](https://cdn.owox.ai/www/webflow/678710d39a2844972be7cd20_59863.png/public)

TIME(1, 30, 0) is one hour and thirty minutes, so 8:00 AM becomes 9:30 AM. The same can be written as a fraction of a day. Adding 0.25 adds six hours:

> `=B5+0.25`

![Google Sheets with the formula =B5+0.25 in D5 returning 9:00 PM for the time 3:00 PM in B5](https://cdn.owox.ai/www/webflow/678710d5f3409d7cfe267a93_59865.png/public)

## Write dates and times inside a formula

A date or a time typed straight into a formula has to be in quotes:

> `="09/15/2024"-"08/15/2024"`

![Google Sheets with the formula =“09/15/2024”-“08/15/2024” in E4 returning 31, the number of days between the two dates](https://cdn.owox.ai/www/webflow/678710d25086eac90d14c12a_59869.png/public)

Without quotes, Sheets reads the slashes as division. `=10/1/2024-9/1/2024` is calculated as 10 divided by 1 divided by 2024, minus 9 divided by 1 divided by 2024, and returns 0.00049 with no error.

![Google Sheets with the formula =10/1/2024-9/1/2024 in E3 returning 0.00049, because the unquoted dates are read as divisions](https://cdn.owox.ai/www/webflow/678710d33171ae816b2075bb_59871.png/public)

An unquoted time is not accepted at all: `=3:00 pm-2:00 pm` is a formula parse error.

![Google Sheets with the formula =3:00 pm-2:00 pm in E5 returning #ERROR! with the message Formula parse error](https://cdn.owox.ai/www/webflow/678710d274fbe516c6c77a25_59873.png/public)

A quoted date is read in the format of the spreadsheet locale, so “09/15/2024” works in a United States locale and fails in one that expects the day first. The [DATE function](/blog/articles/date-functions-google-sheets) has no such problem:

> `=DATE(2024, 7, 4)`

![Google Sheets with the formula =DATE(2024, 7, 4) in B3 returning July 4, 2024](https://cdn.owox.ai/www/webflow/678710d3839e7cedc18d1180_59877.png/public)

DATE(year, month, day) and TIME(hour, minute, second) return real date and time values in any locale.

## The Turning Point

OWOX Data Marts

See your first report built in real time. _15 minutes._

1.  Connect your data warehouse
2.  Pick your metrics
3.  Get a live Google Sheets report

In the time it takes to write a ticket. Then imagine never writing that ticket again.

[Book a Demo](/book-a-call)

We'll use your actual use case

## Combine a date and a time

### Add them

With the date in one cell and the time in another, add the two:

> `=B3+C3`

![Google Sheets with a date in column B, a time in column C and the formula =B3+C3 in E3 returning the date-time October 1, 2024 8:00 AM](https://cdn.owox.ai/www/webflow/678710d266cf2f5e3118c328_59990.png/public)

The result is a real date-time value that you can sort, compare and calculate with. If it shows only the date, apply **Format > Number > Date time**.

### Join them as text

To get a label in a specific layout, format each part with the [TEXT function](/blog/articles/text-function-google-sheets) and join the parts:

> `=CONCATENATE(TEXT(B3, "mm/dd/yyyy"), " ", TEXT(C3, "h:mm AM/PM"))`

![Google Sheets with the formula =CONCATENATE(TEXT(B3, “mm/dd/yyyy”), “ “, TEXT(C3, “h:mm AM/PM”)) in E3 returning the text 10/01/2024 8:00 AM](https://cdn.owox.ai/www/webflow/678710d2f2a4fa83dca6487b_59881.png/public)

`=JOIN(" ", TEXT(B3, "mm/dd/yyyy"), TEXT(C3, "h:mm AM/PM"))` and `=TEXT(B3, "mm/dd/yyyy") & " " & TEXT(C3, "h:mm AM/PM")` return the same string. Keep in mind that the result is text: it looks like a date-time but cannot be used in date arithmetic.

## Split a date-time into date and time

### INT for the date, the remainder for the time

The date is the whole part of the number, and INT returns it:

> `=INT(B3)`

![Google Sheets with timestamps in column B, the formula =INT(B3) in E3 returning the date and a second column returning the time](https://cdn.owox.ai/www/webflow/678710d31d522079b9f0ff07_59889.png/public)

The time is what is left: `=B3-E3`, or in one step with MOD, which returns the fractional part:

> `=MOD(B3, 1)`

![Google Sheets with the formula =MOD(B3, 1) in D3 returning 8:00 AM for the timestamp October 1, 2024 8:00 AM](https://cdn.owox.ai/www/webflow/678710d304172b6b9eff9c1e_59901.png/public)

Both results are numbers. Format the date column as Date and the time column as Time under **Format > Number**.

![The Format menu of Google Sheets open on Number, with Date, Time, Date time and Duration among the options](https://cdn.owox.ai/www/webflow/678710d20257e6d94481b36a_59893.png/public)

### TEXT for formatted text

TEXT returns the part you ask for as text, in the layout you specify:

> `=TEXT(B3, "MM/DD/YYYY")`

![Google Sheets with the formula =TEXT(B3, “MM/DD/YYYY”) in D3 returning the date part of each timestamp as text](https://cdn.owox.ai/www/webflow/678710d412e37090c69d2f93_59897.png/public)

> `=TEXT(B3, "h:mm AM/PM")`

![Google Sheets with the formula =TEXT(B3, “h:mm AM/PM”) in E3 returning the time part of each timestamp as text](https://cdn.owox.ai/www/webflow/678710d23cf62ad42ce04020_59899.png/public)

Use this for labels and exports. For further calculations, INT and MOD are the better choice, because their results stay numbers.

### SPLIT for a quick separation

The [SPLIT function](/blog/articles/how-to-split-cells-in-google-sheets) cuts the displayed value at each space:

> `=SPLIT(B3, " ")`

![Google Sheets with the formula =SPLIT(B3, “ “) in E3 splitting each timestamp into three columns: the date, the time and AM or PM](https://cdn.owox.ai/www/webflow/678710d6796fe9db9c5e9716_59887.png/public)

A timestamp shown as 10/01/2024 8:00 AM has two spaces, so the result has three columns: the date, the time and the AM/PM marker.

### DATEVALUE and TIMEVALUE

> `=DATEVALUE(B3)`

![Google Sheets with the formula =DATEVALUE(B3) in D3 returning the date of each timestamp](https://cdn.owox.ai/www/webflow/678710d2d454451eb6e6d096_59903.png/public)

> `=TIMEVALUE(B3)`

![Google Sheets with the formula =TIMEVALUE(B3) in E3 returning the time of each timestamp](https://cdn.owox.ai/www/webflow/678710d3efb6fd89ce6056ee_59905.png/public)

The two functions return the date and the time of a timestamp. Their main use is for dates and times that are stored as text: they convert the text into real values.

## Insert the current date and time

### TODAY and NOW

> `=TODAY()`

![Google Sheets with the formula =TODAY() in B3 returning the current date](https://cdn.owox.ai/www/webflow/678710d3edd6741d115d4bc4_59909.png/public)

> `=NOW()`

![Google Sheets with the formula =NOW() in B3 returning the current date and time](https://cdn.owox.ai/www/webflow/678710d2979c6559b7a4cb20_59913.png/public)

TODAY returns the current date, NOW the current date and time. Neither takes an argument, and both are recalculated when the sheet changes, so they are not suitable for recording when something happened. More in the guide to [NOW and TODAY](/blog/articles/now-today-functions-google-sheets).

For the current time without the date, subtract the date part:

> `=NOW() - TRUNC(NOW())`

![Google Sheets with the formula =NOW() - TRUNC(NOW()) in B3 returning the current time without the date](https://cdn.owox.ai/www/webflow/678710d31e10c92a5a526e4a_59915.png/public)

`=MOD(NOW(), 1)` returns the same value.

### Keyboard shortcuts for a fixed date and time

A shortcut types the current value into the cell as a constant that never changes:

*   **Ctrl + ; (Cmd + ; on a Mac):** the current date.
*   **Ctrl + Shift + ; (Cmd + Shift + ;):** the current time.
*   **Ctrl + Alt + Shift + ; (Cmd + Option + Shift + ;):** the current date and time.

![Google Sheets with a date entered with Ctrl + ; in C3, a time entered with Ctrl + Shift + ; in C4 and the formula =C3+C4 in E3 returning the combined date-time](https://cdn.owox.ai/www/webflow/678710d2594025e58fefff31_59917.png/public)

Adding the two cells, `=C3+C4`, gives one fixed date-time value.

### A timestamp when a cell is edited

To record automatically when a row was last changed, Google Sheets needs a short script. Open **Extensions > Apps Script**, replace the content of the editor with the code below and save the project:

```
function onEdit(e) {
  if (!e) return; // Exit the function if e is undefined
  var sheet = e.source.getActiveSheet();
  var editedCell = e.range;
  var timestampColumn = 3; // Column C for the timestamp
  var targetColumn = 2; // Column B for target updates

  if (editedCell.getColumn() == targetColumn) {
    var timestampCell = editedCell.offset(0, timestampColumn - targetColumn);
    timestampCell.setValue(new Date());
  }
}
```

*   **onEdit:** Google Sheets runs a function with this name every time a cell is edited by hand.
*   **targetColumn:** the column to watch, here column B.
*   **timestampColumn:** the column that receives the timestamp, here column C.

![Google Sheets with task names in column B and the date and time of each edit written by the script into column C](https://cdn.owox.ai/www/webflow/678710d2640e8d861880c677_59927.png/public)

From then on, every edit in column B writes the current date and time into column C of the same row. The script applies to every tab of the file; the value it writes is fixed and does not change later.

## Sort data by date

### With a filter

1.  Select the range, including the header row.
2.  Choose **Data > Create a filter**.

![The Data menu of Google Sheets with the Create a filter command highlighted](https://cdn.owox.ai/www/webflow/678710d394068a7dd7c86cf5_59931.png/public)

3.  Click the filter icon in the header of the date column and choose **Sort A to Z** for oldest first or **Sort Z to A** for newest first.

![The filter menu of a date column in Google Sheets with the options Sort A to Z and Sort Z to A](https://cdn.owox.ai/www/webflow/678710d27d129ddd26de6fba_59933.png/public)

![Google Sheets with a task list sorted by date from July 25, 2024 to January 15, 2025 after the filter sort](https://cdn.owox.ai/www/webflow/678710d2c5908c5d93a5e41e_59935.png/public)

### With the SORT function

The [SORT function](/blog/articles/sort-and-sortn-functions-google-sheets) returns a sorted copy and leaves the original range as it is:

> `=SORT(B3:C10, 2, TRUE)`

*   **B3:C10:** the range with tasks and dates.
*   **2:** sort by the second column of the range, the dates.
*   **TRUE:** ascending order, oldest first. FALSE reverses it.

![Google Sheets with the formula =SORT(B3:C10, 2, TRUE) in F3 returning the task list sorted by date in ascending order](https://cdn.owox.ai/www/webflow/678710d315bd7490d0897249_59937.png/public)

The copy updates by itself when the source data changes.

### With sort range

1.  Select the rows to sort, here B3:C10.
2.  Choose **Data > Sort range > Advanced range sorting options**.

![The Data menu of Google Sheets open on Sort range with Advanced range sorting options highlighted](https://cdn.owox.ai/www/webflow/678710d2682c8b7b9a128b4a_59941.png/public)

3.  Pick the date column under **Sort by**, choose **A to Z** or **Z to A** and click **Sort**. If the selection includes the header, tick **Data has header row**.

![The Sort range dialog of Google Sheets with Sort by set to Column C and A to Z selected](https://cdn.owox.ai/www/webflow/678710d34aafb780e1a7cd03_59943.png/public)

### The whole sheet

To sort every row of the tab by the date column, freeze the header row first (**View > Freeze > 1 row**), click any cell in the date column and choose **Data > Sort sheet > Sort sheet by column (A to Z)**.

![The Data menu of Google Sheets open on Sort sheet with the options Sort sheet by column C A to Z and Z to A](https://cdn.owox.ai/www/webflow/678710d3a63ef75f3e458e9a_59947.png/public)

### When the dates sort in the wrong order

**⚠️ Error:** Some dates end up in the wrong place, usually together at the top or the bottom.

✅ **Solution:** Those dates are stored as text. A text date is left-aligned by default and does not change when you apply another date format. Convert it with `=DATEVALUE(B3)` or retype it, then sort again. Changing the cell format alone does not turn text into a date.

## Convert between time zones

Sheets has no time zone function. A conversion is a shift by the number of hours between the two zones, and one hour is 1/24 of a day.

### Subtract or add the offset

To convert a UTC timestamp to a zone that is five hours behind:

> `=TEXT(B3 - 5/24, "yyyy-mm-dd hh:mm AM/PM")`

*   **B3 - 5/24:** the timestamp minus five hours.
*   **TEXT(…, “yyyy-mm-dd hh:mm AM/PM”):** shows the result in a fixed layout, as text.

![Google Sheets with UTC timestamps in column B and the formula =TEXT(B3 - 5/24, “yyyy-mm-dd hh:mm AM/PM”) in D3 returning each time five hours earlier](https://cdn.owox.ai/www/webflow/678710d3d932e5ad3382f0ee_59955.png/public)

For a zone ahead of UTC, add instead: `=B3 + 3/24`. Leave TEXT out when you need a value you can keep calculating with.

The same shift can be written with TIME:

> `=B3 - TIME(3, 0, 0)`

![Google Sheets with the formula =B3 - TIME(3, 0, 0) in D3 returning 5:00 AM for the timestamp 8:00 AM, three hours earlier](https://cdn.owox.ai/www/webflow/678710d2f3fe2ae96e6613ad_59959.png/public)

Or with CONVERT, which turns hours into days:

> `=B3 + CONVERT(-3, "hr", "day")`

![Google Sheets with the formula =B3 + CONVERT(-3, “hr”, “day”) in D3 returning each timestamp three hours earlier](https://cdn.owox.ai/www/webflow/678710d2f422d47b54e9629d_59961.png/public)

All three handle the change of date correctly: 1:00 AM minus three hours becomes 10:00 PM of the previous day.

A fixed offset ignores daylight saving time. New York is five hours behind UTC in winter and four in summer, so a formula with a constant offset is right only for part of the year.

### A different zone in each row

With the zone of each row in a column, keep the offsets in a small table and look them up with [VLOOKUP](/blog/articles/vlookup-in-google-sheets):

> `=B3 + VLOOKUP(C3, $B$14:$C$18, 2, FALSE)/24`

*   **B3:** the UTC timestamp.
*   **VLOOKUP(C3, $B$14:$C$18, 2, FALSE):** the offset in hours for the zone named in C3.
*   **/24:** turns the hours into a fraction of a day.

![Google Sheets with UTC timestamps, a time zone code in each row and a lookup table of hour offsets, and the formula =B3 + VLOOKUP(C3, $B$14:$C$18, 2, FALSE)/24 returning the local time](https://cdn.owox.ai/www/webflow/678710d3b1ee7e283d75a8f7_59963.png/public)

## Measure the time between two date-times

Subtract the start from the end:

> `=C3-B3`

![Google Sheets with start and end date-times in columns B and C and the formula =C3-B3 in E3 returning a duration of 4 days, 0 hours and 21 minutes](https://cdn.owox.ai/www/webflow/678710d49d47e6e7e88b3ee1_59967.png/public)

The result is a number of days with a fraction. Format it with **Format > Number > Duration** to see elapsed hours, minutes and seconds, or multiply it: `=(C3-B3)*24` gives the difference in hours as a plain number.

When the two timestamps were recorded in different time zones, bring one of them to the zone of the other first, then subtract:

> `=D3-B3`

![Google Sheets with a start time in one time zone, an end time in another, the end time adjusted to the first zone in column D and the formula =D3-B3 returning the duration](https://cdn.owox.ai/www/webflow/678710d2bd916c44324d0b00_59969.png/public)

Here column D holds the end time shifted to the time zone of the start time.

## Related Google Sheets functions

Functions that are often used with dates and times, each with its own guide:

*   [DATE functions](/blog/articles/date-functions-google-sheets): DATE, EDATE, DATEVALUE and DATEDIF for building and comparing dates.
*   [TIME functions](/blog/articles/time-functions-google-sheets): TIME, HOUR, MINUTE and SECOND, and time arithmetic.
*   [NOW and TODAY](/blog/articles/now-today-functions-google-sheets): The current date and time.
*   [WEEKDAY/WEEKNUM](/blog/articles/weekday-weeknum-functions-google-sheets): Returns the day of the week or the week number of the year for a date, useful for weekly reporting.
*   [MONTH/EOMONTH](/blog/articles/month-eomonth-functions-google-sheets): Extracts the month from a date or returns the last day of a month, handy for monthly reports.
*   [WORKDAY and NETWORKDAYS](/blog/articles/workday-networkdays-functions-google-sheets): Working days between dates.
*   [TEXT](/blog/articles/text-function-google-sheets): Converts numbers and dates into text in the format you specify.
*   [QUERY date filtering](/blog/articles/date-filtering-with-query-google-sheets): Filters rows by a date or a date range inside a QUERY formula.

## Clean dates start before the sheet

Most date problems in a spreadsheet are not formula problems. They come with the data: one export writes 10/01/2024, another 2024-10-01 as text, a third one is in UTC while the rest is in local time. Every fix in this guide, from DATEVALUE to time zone offsets, repairs something that was already inconsistent when it was pasted in.

The [OWOX Data Marts extension for Google Sheets](https://workspace.google.com/marketplace/app/owox_data_marts/94902851409) covers that half. A data analyst publishes a data mart (a table or an SQL query in your data warehouse) and makes it available for reports. In Sheets you open the extension, pick the data mart, tick the columns you want and run it. The rows land in a tab, ready for your formulas.

![Google Sheets with the OWOX Data Marts extension open beside an ad spend table: the Unified Ad Spend data mart, nine of fourteen columns ticked and a Save & Run button – the rows in the sheet come from a governed data mart, not a pasted export](https://cdn.owox.ai/www/content-marketing-article/dates-and-times-google-sheets/screens/1.png/public)

What changes for the person who maintains the sheet:

*   **Refresh replaces re-export.** _Refresh current report_ in the extension menu re-runs the same pull, and a scheduled refresh keeps the tab current without anyone touching it.
*   **The source is written on the sheet.** The header cell of an imported tab carries a note with the data mart it came from, the time of the import and a link to the report.
*   **No SQL and no warehouse access needed.** The analyst decides which data marts and columns are available. You choose from that list.

The extension does not write or change the analyst’s SQL. Formats and time zones are settled there once, and the sheet receives the same columns in the same form on every refresh. The extension comes with the OWOX Cloud plans of [OWOX Data Marts](https://www.owox.com/app-signup); [spreadsheet reporting](/features/spreadsheet-reporting) describes both ways data reaches a sheet.

## Your New Normal

Turn your data into decisions.

Governed data marts give you the clean foundation ML needs to actually work.

*   No AI hallucinations
*   Analyst-governed definitions
*   Every number traces to SQL

[Get started free](https://www.owox.com/app-signup)

## FAQ

## Frequently Asked Questions

Can I automate the insertion of a timestamp when editing a cell in Google Sheets?

Yes, you can automate the insertion of a timestamp when editing a cell in Google Sheets by using Google Apps Script. Create a script that triggers on edit, capturing the current date and time, and inserting it into a specified cell or column whenever a change occurs.

What’s the easiest way to split date and time into separate columns?

Use =INT(A1) for the date and =MOD(A1, 1) for the time, where A1 holds the date-time value, then format the first result as Date and the second as Time. Both results stay real values that you can sort and calculate with. For text output, use =TEXT(A1, "mm/dd/yyyy") and =TEXT(A1, "h:mm AM/PM").

How can I sort data by date in Google Sheets?

To sort data by date in Google Sheets, select the range of cells containing your data. Then, click on "Data" in the menu and choose "Sort range". Select the column with the dates and specify whether to sort in ascending or descending order, then click "Sort".

How do I convert a timestamp to a different time zone in Google Sheets?

To convert a timestamp to a different time zone in Google Sheets, use the formula =A1 + (TIMEZONE\_OFFSET/24), where A1 contains the original timestamp and TIMEZONE\_OFFSET is the difference in hours between the original and target time zones. Format the result as a date-time for clarity.

How do I automatically insert the current date or time in Google Sheets?

To automatically insert the current date in Google Sheets, use the formula =TODAY(). For the current time, use =NOW(). These functions update automatically with changes to the spreadsheet, providing the most current date and time without manual input.

How can I combine date and time in Google Sheets?

To combine date and time in Google Sheets, utilize the formula =A1 + B1, where A1 represents the cell containing the date and B1 contains the time. Ensure the resulting cell is formatted as a date-time format by navigating to Format > Number > Date time for proper display.

## Who wrote this

![Vadym Kramarenko](https://cdn.owox.ai/www/webflow/6798e703afdf787334941cde_Vadym-Kramarenko.png/public)

[Vadym Kramarenko](/team/vadym-kramarenko) · Growth Marketing Manager

Vadym Kramarenko is a Growth Marketing Manager at OWOX, where he drives user acquisition and product-led growth strategies. He hosts the OWOX podcast, interviewing analytics professionals about data-driven marketing, attribution, and reporting best practices. Vadym specializes in turning complex analytics concepts into practical, actionable marketing frameworks.

[LinkedIn](https://www.linkedin.com/in/vadim-kramarenko/) · [All articles](/team/vadym-kramarenko)

[Google Sheets Tips](/blog/topics/google-sheets-tips)

## Related articles

[Google Sheets Tips · Pivot tables in Google Sheets: how to create and use them · October 2, 2026](/blog/articles/pivot-tables-google-sheets)

[Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: join two columns · October 2, 2026](/blog/articles/query-with-concatenate-google-sheets)

[Google Sheets Tips · QUERY with IMPORTRANGE in Google Sheets: formula, examples · October 2, 2026](/blog/articles/query-with-importrange-google-sheets)

[See all articles →](/blog/articles)

## Book a call

You are booked. The invitation is on its way to , with the calendar invite and the meeting link.

[Reschedule](#)

[Cancel](#)

## Links

Pages this page links to, on this site and on docs.owox.com. Where the page has a Markdown twin, its address follows the link.

- [Google Sheets Tips](https://www.owox.com/blog/topics/google-sheets-tips) — /blog/topics/google-sheets-tips.md
- [Vadym Kramarenko](https://www.owox.com/team/vadym-kramarenko) — /team/vadym-kramarenko.md
- [TIME function](https://www.owox.com/blog/articles/time-functions-google-sheets) — /blog/articles/time-functions-google-sheets.md
- [DATE function](https://www.owox.com/blog/articles/date-functions-google-sheets) — /blog/articles/date-functions-google-sheets.md
- [Book a Demo](https://www.owox.com/book-a-call) — /book-a-call.md
- [TEXT function](https://www.owox.com/blog/articles/text-function-google-sheets) — /blog/articles/text-function-google-sheets.md
- [SPLIT function](https://www.owox.com/blog/articles/how-to-split-cells-in-google-sheets) — /blog/articles/how-to-split-cells-in-google-sheets.md
- [NOW and TODAY](https://www.owox.com/blog/articles/now-today-functions-google-sheets) — /blog/articles/now-today-functions-google-sheets.md
- [SORT function](https://www.owox.com/blog/articles/sort-and-sortn-functions-google-sheets) — /blog/articles/sort-and-sortn-functions-google-sheets.md
- [VLOOKUP](https://www.owox.com/blog/articles/vlookup-in-google-sheets) — /blog/articles/vlookup-in-google-sheets.md
- [WEEKDAY/WEEKNUM](https://www.owox.com/blog/articles/weekday-weeknum-functions-google-sheets) — /blog/articles/weekday-weeknum-functions-google-sheets.md
- [MONTH/EOMONTH](https://www.owox.com/blog/articles/month-eomonth-functions-google-sheets) — /blog/articles/month-eomonth-functions-google-sheets.md
- [WORKDAY and NETWORKDAYS](https://www.owox.com/blog/articles/workday-networkdays-functions-google-sheets) — /blog/articles/workday-networkdays-functions-google-sheets.md
- [QUERY date filtering](https://www.owox.com/blog/articles/date-filtering-with-query-google-sheets) — /blog/articles/date-filtering-with-query-google-sheets.md
- [OWOX Data Marts](https://www.owox.com/app-signup)
- [spreadsheet reporting](https://www.owox.com/features/spreadsheet-reporting) — /features/spreadsheet-reporting.md
- [Google Sheets Tips · Pivot tables in Google Sheets: how to create and use them · October 2, 2026](https://www.owox.com/blog/articles/pivot-tables-google-sheets) — /blog/articles/pivot-tables-google-sheets.md
- [Google Sheets Tips · QUERY with CONCATENATE in Google Sheets: join two columns · October 2, 2026](https://www.owox.com/blog/articles/query-with-concatenate-google-sheets) — /blog/articles/query-with-concatenate-google-sheets.md
- [Google Sheets Tips · QUERY with IMPORTRANGE in Google Sheets: formula, examples · October 2, 2026](https://www.owox.com/blog/articles/query-with-importrange-google-sheets) — /blog/articles/query-with-importrange-google-sheets.md
- [See all articles →](https://www.owox.com/blog/articles) — /blog/articles.md