Stack Exchange Network

Stack Exchange network consists of 174 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 [date]

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

0
votes
0answers
7 views

Day based Weekly Schedule for a particular date range

I would like my clients to specify a date range and then on a corresponding table or otherwise, specify the days of the week and the start and end times within this period they would like service. e....
1
vote
0answers
37 views

Difficulty appending to cell in Google Sheets

My goal is to automate making a calendar on Google Sheets. I used =DATE(C1,A1,B1) to make a date and then each following cell, I added 1 to the previous cell. However, now I want to also automate ...
0
votes
1answer
24 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 ...
0
votes
1answer
157 views

How to make Google Sheets jump to closest date to today when opened?

I have a Google sheet containing a list of events, with event dates listed in one column. I'd like to have my Google Sheets spreadsheet jump to the closest date to today's date on opening (i.e., ...
0
votes
0answers
235 views

Date comparison and DATEVALUE with dd.mm.YYYY. date format

I'm using the custom date format for one of my columns, dd.mm.YYYY.. I want to compare that date to TODAY(), by using +AND($D2 < TODAY()) where column D is the one with the dates in dd.mm.YYYY. ...
0
votes
1answer
739 views

Google Docs date in yyyy/mm/dd format (year first)

My question is similar to Google Docs date in “dd/MM/yy” format and How can I change the input format for dates in Google Docs' spreadsheet? BUT unlike those answers, I'm trying to get the ...
0
votes
3answers
4k views

Shortcut to insert current date in Google Docs

For example, in MS Word I can insert current date by typing current year and dash 2018- // ... and current date appears automatically, like 2018-05-20 Sun Is there something similar in Google Docs?
0
votes
0answers
12 views

Get the day of the year in Zapier

I'd like to get the day of the year as an integer in Zapier for a scheduled task (e.g 1st February would be 32). What's the simplest way to achieve this? I think something like ((X(CurrentDate) - X(1/...
0
votes
1answer
41 views

Plus or minus quarters in Google Sheets using formulas

I have a date format like this 1Q16 2Q16 3Q16 4Q16 Is there a way to get... input: 1Q16 + 4 output: 1Q17 and... input: 1Q16 - 3 output: 2Q15 ... using formulas only and not code?
1
vote
1answer
2k views

How to validate a date in Google Forms?

Google Forms include the possibility to perform some sort of validation on user input for checkboxes and text; the functionality is available very easily both via the UI and the API. Unfortunately, it ...
1
vote
1answer
27 views

Format Google Analytics Date

I'm using the following formula to retrieve week day and day from a Google Analytics report in Google Spreadsheet: =CONCATENATE(CHOOSE(WEEKDAY('90diaspessoas'!A16),"Domingo","Segunda","Terça","Quarta"...
0
votes
0answers
35 views

Google sheets query multi conditional date cell ref

I have a doubt regarding a change in this formulas in sheets: =INDEX(QUERY($A$3:$H; "SELECT sum (D) where C='Pub'");2) =INDEX(QUERY($A$3:$K; "SELECT sum (F) where C='Reg'and K='"& K15&"'");...
0
votes
0answers
30 views

How to add minutes to Google “Date Time” format?

Google Sheets has a special "Date Time" format, apart from Date and Time. I am unable to understand the benefit of this. I am even unable to add minutes to this date time format. What is its use and ...
1
vote
0answers
137 views

Google search by time frame anomaly

I'm trying to understand the logic Google search uses when I use the time frame filter. In the first search, I restrict results to "Past 24 hours": In the second search, I restrict to "Past week" : ...
5
votes
1answer
140 views

Display dates in ISO 8601 format in the Microsoft Outlook web interface

Is it possible to display the dates in ISO 8601 format in the Microsoft Outlook web interface? I read on https://support.office.com/en-us/article/Time-zone-and-language-settings-in-Outlook-Web-App-...
0
votes
1answer
55 views

Use calculation to provide the next Friday based on submission date

I will have our users input "today's" date on a form, and I want the next field to auto-populate to the next Friday: So if the submission date is 9/25/2017, the calculated field would be 9/29/2017. ...
-3
votes
1answer
216 views

Need to convert a date into a dayname [closed]

I tried this: text(WEEKDAY(2018/1/1; 1);"dddd") that returns "monday" (correct), but text(WEEKDAY(2018/1/2; 1);"dddd") returns sunday (error) and text(WEEKDAY(2018/1/3; 1);"dddd") returns saturday (...
2
votes
1answer
822 views

Date Format Lost When Combining Two Cells Using “&” and CONCATENATE in Google Sheets

I'm trying to figure out "how to" maintain the date format when I concatenate a date formatted cell with a nondate formatted cell. Result: The Date Format Is Lost Formulas Used Desired Result: I ...
-1
votes
1answer
51 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 ...
0
votes
1answer
2k views

Can I sort rows in Google Sheets by date?

In Google sheets I'm trying to sort rows according to a date column. According to my experience I can use column filtering and choose to sort data from A-Z. However this will give a wrong result for ...
4
votes
0answers
32 views

Display dates in ISO 8601 format in Mint

Is it possible to display the dates in ISO 8601 format in the transaction tables on Mint?
1
vote
1answer
102 views

Formula to compute the cardinality of the intersection of two sets of dates

Given: Two dates, the bounds of a date range; A list of dates (given in-extenso in a line or a column); Is there a way, in Google Spreadsheet, to get the number of dates (days) in the date range ...
0
votes
1answer
98 views

Misinterpreted hours and minutes in Google Apps Script while reading Google Spreadsheet data

I have a datetime columns in Google Spreadsheet which I'd like to iterate and use "hour" value to calculate something in custom Google Script. This is an example of a value I have in Spreadsheet: My ...
5
votes
2answers
1k views

How to sort Trello cards by date added

Trello is rad. But one thing I haven't figured out: How to sort cards in a list by the date that the cards were added to the list (or to the board)? Also, is it possible to show (as a custom field?) ...
1
vote
2answers
48 views

Need to identify when a specific amount of time has past given a specific span of time

I have a start date and a payout date which is 70 days from the start date. Throughout the year I need to know when each time 70 days has past and when it does is that date between the start and ...
6
votes
3answers
7k views

Change date format [YYYYMMDD] to [MM/DD/YYYY]

I generated a report that formats date as 20160509 and my Google Sheets locale is already set to United States. I've played around with various options within Format > Number > Date Format but I can't ...
-1
votes
1answer
679 views

Google sheets - How to use Now() to subtract from column of date/time to get hour difference

I have searched a bit and can't figure this out. I've tried using Now() in the formula along with putting it in a cell and running the formula against it. I have a column of date/times. I would ...
1
vote
1answer
8k views

Trying to subtract X days from a defined date in Google Sheets

I'm trying to figure out "how to" subtract days from a date in Google Sheets. EXAMPLE Col A (original date) Col D (date - 5 days) 08-08-16 08-03-16 A1 will display the ...
2
votes
1answer
103 views

Google sheets recently changed American datetime format, how do I change it back?

Google sheets recently changed American datetime format, how do I change it back? It used to default to using "MM/dd/yyyy" but as of a couple weeks ago now when I enter a date it defaults to "MM/dd" ...
-1
votes
1answer
891 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 "...
4
votes
1answer
368 views

How to edit dates in Google Sheets as ISO 8601?

I know how to make Google Sheets display dates in ISO 8601 format (YYYY-MM-DD). Now, how do I make them not only display, but edit in the same format? See the edit line below: Moreover, if that is ...
3
votes
2answers
1k views

Google sheets MM-DD-YYYY to DD-MM-YYYY

I downloaded CSV data from my Etsy shop to calculate taxes. I'd like to have the date "copied" properly. The CSV date I get from Etsy is formatted as "02/09/16" This is "2 September 2016" in Dutch ...
1
vote
1answer
29 views

How can I get the halfway date of two dates in Google Sheets?

I have two date columns in mm-yy format and I need to know the halfway date of these two. What formula do I use? I tried simple subtraction of the two dates and then divided it by two but it didn't ...
1
vote
1answer
2k views

How to convert text of the form Month-Year to date format?

How do I convert the text "Oct-14" to date, so that it's being read as "Oct 01, 2014. I tried to go to Format > Date and selected the format: Oct-2014, but google sheets is interpreting it as "Oct 14, ...
4
votes
1answer
3k views

Insert current date to cell based on content in other cell

Background: I am trying to create a sheet which tracks my costs on daily basis. Instead of entering the current date everyday, I want the sheet to store the current day based on the content I enter ...
2
votes
1answer
837 views

Why does Google Spreadsheet use days as unit of time when entering a number?

When using Google Spreadsheet today, I noticed that when entering a date as a simple number sequence (e.g., 151127), and choosing date as format, it ended up being a completely different date than the ...
-1
votes
1answer
929 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?
2
votes
2answers
77 views

Date automation down columns

I know how to get Google Spreadsheets to automate dates down a column. Write a date, left click on the crosshair in the bottom right hand corner, drag down and let go. The thing I'm hoping to do ...
2
votes
1answer
555 views

How to hide date on Tumblr pages?

The documentation on Tumblr (https://www.tumblr.com/docs/en/custom_themes#dates) says {block:Date} {/block:Date} Rendered for all posts. Always wrap dates in this block so they will be ...
5
votes
2answers
2k views

How to add a line break in a custom date format in Google Spreadsheets?

Google Spreadsheets give us a tool to create and use a customized data format for date values. While the tool allows us to use arbitrary characters, like slashes and commas between the date fields (...
2
votes
1answer
170 views

Cognito Form with Blackout dates and date functions

Is there a way to have "blackout" dates on my form? I rent equipment and when all equipment is rented out, I want to be able to black out specific dates.
1
vote
3answers
11k views

Conversion from object to string in Google Apps Script

I'm trying to take information from Google Sheets and use it to send an email with the information given in sheets. I have the email part down, but when I try to editAsText to delete unwanted ...
3
votes
1answer
623 views

How to enter a date in a cell and have the date for one week later automatically fill another cell?

I want to be able to type in a date in one cell, and then automatically have the date that is seven days from the date I typed appear in another cell in that same row under a different column. How do ...
3
votes
1answer
303 views

Google Docs date capitalisation script

I'm using a script that was posted here on Web Applications: Is there a way to insert today’s date into a Google Docs?. I changed the way the date is formatted to: ddMMMyyyy but want 01JAN2015 - the ...
0
votes
1answer
218 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?
2
votes
1answer
270 views

Find the date of a Blogspot blog comment

I'm trying to find the date of comments on a Blogspot blog (which is not mine). Unfortunately, all that is listed is the time of the comment, but that information is useless without knowing what date ...
1
vote
3answers
2k views

Date autofill increments year instead of day

Earlier, when I had dates in a column like: Monday, 21 April, 2014 Tuesday, 22 April, 2014 and I extended the last cell to lower cells I could expect them to be filled with following days: ...
7
votes
3answers
2k views

How can I change Google Spreadsheets to have iso 8601 dates as default?

I would love to set my default date-setting to be iso 8601 (relevant xkcd) for all of my Google Spreadsheets. I'm well aware that I can manually change the date-format for a given spreadsheet by: ...
2
votes
1answer
870 views

How to make my Google Spreadsheet automatically calculate “days since”

I have a spreadsheet with several columns and one of them is for date (column D). How do I make the next column (E) automatically display the days passed from date in D until now on open? I have ...
1
vote
1answer
5k views

Date format in Google Spreadsheet is not correct

Whenever entering the date e.g. day-month-year, it automatically changes to month-day-year. I went into format>number>more formats>more date and time formats, and I changed it to day-month-year. And ...