Stack Exchange Network

Stack Exchange network consists of 175 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [google-sheets-dates]

Use for questions related to how Google Sheets handle dates.

2
votes
1answer
4k views

Dynamic date range query

I'm trying to create two cells that will update my query: A >= date"A1" and A <= date "B1". My goal is to create a search page for the data, where the end user could insert a date or the =today() ...
3
votes
1answer
8k views

Entering mm:ss: milliseconds into Google Sheets for time duration (arithmetic)

I would like to enter times mm, seconds, milliseconds into Google Sheets and subtract times to determine duration. I use format> numbers > More formats > more dates and times > and apply mm:ss: ms. I ...
-1
votes
1answer
205 views

How to find the closest date to today from a list of dates

I have a list of dates on column A. Each day I need to automatically put the date of today or the next closest date on cell B1. 20/8/2018 6/9/2018 25/9/2018 28/9/2018 11/10/2018 30/10/2018 31/10/2018 ...