Questions tagged [date]

Reference to a time interval of one day during a month and year. Not to be used for the 'social engagement' meaning.

Filter by
Sorted by
Tagged with
0
votes
1answer
267 views

How to turn cell yellow if date in cell is between 180 and 365 days in the past

In Google Spreadsheets how do I use conditional formatting to turn a cell yellow if the date is between 180 and 365 days in the past?
0
votes
2answers
4k views

List of dates of current and previous month in Google Sheets

I want to have the dates of the current month and the previous month automatically get populated. So I'm using =MONTH(NOW()) to get the current month and =MONTH(NOW())-1 to get the previous month. ...
0
votes
1answer
718 views

Google Sites File Attachment Date and Time

I live in the Central Time Zone. When I attach a file in my Google Site, it shows Pacific Time for the Attachment Time. Is there anyway to have it show Central Time?
0
votes
1answer
24 views

Query or filter the data when using date time format

Example sheet. Sheet2 In cell A2 I have: =QUERY(Sheet1!A1:Q, "Select * where B >= datetime '"&TEXT($A$1,"MM-DD-YYYY HH:mm:ss")&"'") In cell A1 I have: 6/17/...
0
votes
1answer
27 views

Time until Specified Date

Looking to add an auto-updated amount of time countdown timer into Google Slides with the working script from this question. Getting Setup Go to Google Slides Create a text box, right click to find ...
0
votes
1answer
17 views

Changing cells formatting based on another cells date

I've been looking and can't quite find the answer I'm looking for. I have a spreadsheet with columns Monday through Saturday with data lining up underneath. I would like the current day to highlight ...
0
votes
1answer
370 views

Query not working unless I change the Date format to Automatic [duplicate]

Query works fine if I change Hudson F to Automatic, if I change it to date it stops working. I need to view F as date and have the query work =QUERY(Hudson2000!1:6634, "SELECT A, B, C, D, F, G WHERE ...
-1
votes
1answer
2k views

An “Updated on” field that records the last time that a particular column changed [duplicate]

Is it possible to create a "last updated" field under Google Sheets? I have a status column, where the status progresses something like: New -> Pending -> Started -> Done I would like to add a "...
-1
votes
1answer
54 views

Look for today() in range D5:AP5 is X in the range D8:AP8

I used this formula: - Look for "X" in range D8:AP8 = found/not found, which is fine. Formula: =IF(ISERROR(MATCH("X";NW_Calendar!D8:AP8;0));"Not found";"Found") but I would like to have it like ...
-1
votes
1answer
1k views

Search Google with a date/time range

I want to restrict Google search to a specific date/time range. How can this be done?

1
2