Skip to content
Sheets Help

Tips, tutorials, and add-ons

  • Basics
  • Tutorials
  • Add-Ons

function

WEEKDAY Function – Google Sheets

December 3, 2025December 3, 2025 Adam Steinfurth

The WEEKDAY function returns a number representing the day of the week for a specific date. By default, it counts Sunday as <code>1</code> and Saturday as <code>7</code>, but you can change this using the optional <code>type</code> argument. The date must be in a valid format, so you have to use the DATE function, wrap it … Read more

Categories Date parts Tags date, dayofweek, function, weekday, weeks

TRAVELTIME_API Formula – Google Sheets

August 27, 2025August 13, 2025 Adam Steinfurth

Use the TRAVELTIME_API formula to calculate the travel time between two locations. The paid version has unlimited daily usage and can avoid features like tolls and ferries.

Categories Add-on Tags function, google maps, time, travel, travel formulas, travel time, trip

TRAVELTIME Formula – Google Sheets

October 30, 2025July 4, 2024 Adam Steinfurth

Learn how the TRAVELTIME formula calculates the trip duration between two locations.

Categories Add-on Tags function, google maps, time, travel, travel formulas, travel time, trip

Difference Between Two Times in Seconds Using Google Sheets

December 13, 2024May 8, 2023 Adam Steinfurth

Find the difference between two times in seconds.

Categories Tutorials Tags date, duration, function, seconds, TEXT, time

TEXT Function – Google Sheets

September 24, 2024April 25, 2023 Adam Steinfurth

Format numerical data

Categories Text Tags format, function, TEXT
Older posts
Page1 Page2 … Page5 Next →
StaySorted moving a row automatically

Get the Sheets Add-On
  • Home
  • Subscriber Portal
  • Functions
  • About
  • Contact
© 2025 Sheets Help • Built with GeneratePress