We changed our privacy policy. Read more.

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
3
votes
1answer
814 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 ...
15
votes
4answers
7k views

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

I would love to set my default date format 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: ...
0
votes
0answers
8 views

Date computation dependent on another cell that has a data validation option

I am working on a lead generation tracking spreadsheet in Google Sheets with the hopes of having a follow-up date auto-populate. There are different amounts of time when we want to follow up with ...
0
votes
2answers
16 views

How to extract the decimal fraction of a number for a formula?

For a column where years and months are entered as 1.02 for one year and two months, or 3.04 meaning three years and four months, how is that converted to a date? Or just expressed so that it's base ...
0
votes
1answer
22 views

Submission time removal

I am looking for a way to remove the submission date/time from the items seen when looking at entries in the Cognito forms. I have multiple employees that I am ok with them working after hours but the ...
0
votes
1answer
49 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 ...
7
votes
2answers
25k views

Automatic date in Google Docs

Is there a way in Google Docs to automatically update the date in a header of the page, so that whenever I print the document it will have today's date?
1
vote
1answer
26 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
30 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
33 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 ...
0
votes
1answer
24 views

How can I calculate the difference between two time fields, being the second greatest than the first one?

I'm having trouble getting negative hour as a result. For instance: G H 08:30 06:00 I would like to get a column with the difference between H and G. So I would be filled with -02:30. ...
12
votes
3answers
6k 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 (...
1
vote
2answers
55 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 ...
0
votes
1answer
354 views

How to open a specific tab based on today's date (Google Sheets)

I've made a 'Google Sheets' with 31 tabs for the dates of the month (1-31) How do I write a script that makes the spreadsheet open to that days tab? e.g. open tab 25 if today is Aug 25th I imagine (...
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 ...
7
votes
1answer
26k 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 ...
5
votes
1answer
6k 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 ...
16
votes
6answers
83k 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 ...
2
votes
1answer
50 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
1
vote
2answers
11k 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 ...
2
votes
1answer
42 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 ...
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 ...
2
votes
1answer
60 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
2answers
5k 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. ...
53
votes
4answers
176k 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 ...
2
votes
1answer
262 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
1answer
4k 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
1answer
243 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

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
1answer
562 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
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 ...
1
vote
1answer
48 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
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 ...
2
votes
3answers
3k views

Pre-fill a cell with today's date [duplicate]

I would like a certain cell of mine to display today's date when I starts a new row. Is it possible?
3
votes
1answer
354 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 ...
1
vote
3answers
34k 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 ...
0
votes
1answer
251 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 ...
9
votes
1answer
28k 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 ...
0
votes
1answer
6k 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 ...
5
votes
1answer
345 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-...
4
votes
2answers
5k 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
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 "...
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 ...
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 ...
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
8k 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
203 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
vote
3answers
10k 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: ...
5
votes
1answer
914 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 ...
1
vote
1answer
180 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 ...