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.
65
questions
50
votes
4answers
169k views
How can I search for Gmail messages on a particular date?
I'm searching for a message on or about a particular date and rather than scrolling through my emails to go back about a year, I'd like to know a search method to only find emails from a particular ...
14
votes
4answers
5k 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:
...
13
votes
6answers
71k views
Advanced date logic in Google Spreadsheets
I have the following situation:
Today is 4/9/12. I have a cell with a date in the sheet that is
4/13/12. This cell should turn red since it is within 7 days from the
current date.
What is a ...
11
votes
3answers
5k 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 (...
9
votes
2answers
2k views
Analyse frequencies of date ranges
I have a Google Spreadsheets where I would like to compute occurrences of date ranges. I have a column date_utc+1 which contains almost random date data.
What I would like to do is put the date ...
8
votes
1answer
23k views
How do I make a cell highlighted if the date in the cell is today? [duplicate]
Possible Duplicate:
Advanced date logic in Google Spreadsheets
I have a spreadsheet with many consecutive days. So Cell1 = 7/30/2012, Cell2 = 7/31/2012 etc. I want Cell1 to be highlighted if ...
6
votes
1answer
1k views
Search Engine that will return results based on date
Is there a way to use a search engine, preferably Google, that will yield results based on a date?
For example, I would like to search on a term and only return results as if I was searching for that ...
5
votes
1answer
5k 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 ...
5
votes
1answer
9k views
How do I change date format at top of day in Google Calendar?
I can change the date format for most dates displayed by my calendar to Irish format, however I can’t find how to change this one.
The dates at the top of each day are shown as 5/17 or Month/Day—as a ...
5
votes
2answers
2k 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?) ...
5
votes
1answer
281 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-...
5
votes
1answer
24k views
How can I use Google Spreadsheet to format Date in DD/MM/YYYY format?
First thing's first: my spreadsheet's locale is properly set to UK:
If I paste in the following date:
30/09/2013 21:15
Then click Format > Number > Date time
Nothing changes. I also can't seem ...
4
votes
1answer
767 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
1answer
23k 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 ...
3
votes
2answers
4k 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 ...
3
votes
1answer
459 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 ...
3
votes
1answer
2k 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 ...
3
votes
1answer
748 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
336 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 ...
2
votes
3answers
3k views
Pre-fill a cell with today's date
I would like a certain cell of mine to display today's date when I starts a new row.
Is it possible?
2
votes
1answer
2k 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 ...
2
votes
1answer
1k 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 ...
2
votes
1answer
7k views
Convert a date in Google Spreadsheet?
I have a Google Spreadsheet with a date row in UTC time, such as 12/6/2012 11:14:32
I want GMT+2 local time, so how can I convert the date in Google Drive?
And, if not possible, is there a way to do ...
2
votes
1answer
2k views
Date format in spreadsheet (google doc)
I want to create spreadsheets to record the money I spend each year.
Each file is named as Cost-2012, Cost-2013,...etc.
Inside each file, there are in fact 12 sheets, which are named as 01, 02, ..., ...
2
votes
1answer
47 views
How to add every Sunday in sequential order with 3 blank cells under each date?
How to add every Sunday in sequential order with 3 blank cells under each date?
For example:
March 22
Blank cell
Blank cell
Blank cell
March 29
etc etc
2
votes
2answers
90 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
9k 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 ...
2
votes
1answer
37 views
Date highlighting of a cell, separated by weeks, given only a starting date and a cell range
I am trying to build a "life calendar" similar to this - https://labs.coruscantconsulting.co.uk/life/weeks/ - in Google Sheets.
I have the manually designed sheet finished, but want to add the ...
2
votes
1answer
193 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" ...
2
votes
1answer
242 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.
2
votes
1answer
57 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 ...
2
votes
1answer
674 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 ...
1
vote
2answers
65 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 ...
1
vote
1answer
3k 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., ...
1
vote
1answer
2k 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 ...
1
vote
1answer
182 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
2answers
49 views
I wrongly set the date of 2000 cells. I want to add 20 years of those cells. How?
My first thought was to
add a duplicate cell and show the formula as general number.
add another cell that adds 20 years worth of days.
change the third cell formula back to date.
But I feel like ...
1
vote
1answer
46 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"...
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, ...
1
vote
3answers
29k 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 ...
1
vote
3answers
8k 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:
...
1
vote
1answer
512 views
Conditional formatting for dates in Google sheets
I work at a language school and I have a column giving the students expected arrival date.
I want to set conditional formatting to:
Highlight in red any date that is older than 1 week
Highlight in ...
1
vote
2answers
20 views
How can I display Google Sheets dates as Month-Day with the underlying data in UTC format (YYYY-MM-DD)?
I want to display a date in Google Sheets as Month-Day (e.g. Jan-10) with the underlying data as: 2021-01-10
However in order to show Jan-10, Google Sheets defaults the underlying data to 01/10/2021 ...
1
vote
1answer
20 views
Add '/' character in between a number (which should be formatted as a date) and turn it to a date
I have received a spreadsheet which has the dates formatted with only numbers without separators and I would like to transform them into a date format. For example, I would like to change the number ...
1
vote
1answer
28 views
Sum depending on value of Column B and Date in Column C
Column A: Name
Column B: Date (mm/dd/yy)
Column C: Value
I want to sum column C every time column A is a specific name & the corresponding date is before 2020
Small sample/Example of what I'm ...
1
vote
2answers
9k 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
162 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
148 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?
0
votes
1answer
5k views
Auto date added to adjacent cells when data is entered
I am trying to create a spreadsheet to track student loan outs that will automatically put the date in an adjacent cell. The spreadsheet would be set up like this:
Column 1 would be "name"
Column 2 ...
0
votes
1answer
247 views
Entering local date on Google Sheets
If I use the shortcut CTRL+; the date that is pasted is the server date. I have changed the settings so my Time zone is selected to my local time.
Shouldn't my local time get pasted as opposed to the ...
