2022 Developer Survey is open! Take survey.

Hot answers tagged

6 votes

Advanced date logic in Google Spreadsheets

In case you need more precise times than in the accepted answer, you can use DATEDIF to specify a certain difference between dates. Example: format cell A1 if date in A1 is older than 10 days. ...
user avatar
6 votes
Accepted

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

You can do the formatting on the fly: =text(B2,"m/d/yyyy")&C2 Google Sheets Help: TEXT()
user avatar
  • 16.6k
5 votes

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

Google Sheets will both receive a number format with multiple lines and display cells using it: The problem is that the "Custom number format" input field does not support line breaks/...
user avatar
  • 151
5 votes

How to sort Trello cards by date added

You can use Butler for Trello, which is a bot that automates Trello (I'm the author). This command: sort list "X" by time in list sorts a list by the length of time that a card has been in the list. ...
user avatar
  • 381
4 votes

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

I believe that the only way to achieve this is to set a locale in which this date format is a default one. For example I have it as default because I have Polish locale. Link to settings: https://...
user avatar
  • 151
4 votes
Accepted

How to make my Google Spreadsheet automatically calculate "days since"

Use the formula =IF([cell on same row in D column] <> "", today()-[cell on same row in D column], "") So in D2 (for example): =IF(D2 <> "", TODAY()-D2, "") TODAY() returns the current ...
user avatar
  • 2,478
4 votes
Accepted

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

You have to click on the setting button (the wheel) right when the page is loading, before your name appears on the top right. If you do so, then the setting menu has many more entries, including ...
user avatar
3 votes
Accepted

Find the date of a Blogspot blog comment

At the bottom of most Blogspot posts you will find a link like the following: Subscribe to: Post Comments (Atom) When you click on that it will show you a code dump. It is the RSS feed for that ...
user avatar
3 votes

How can I search for Gmail messages on a particular date?

For emails on a particular date (e.g. on 12 July 2017) enter this in search box: after:2017/7/12 before:2017/7/13
user avatar
  • 139
3 votes

Advanced date logic in Google Spreadsheets

The accepted answer mentions colours that are not mentioned in the question and only looks back. Also "Date is before" "in the past week" does not highlight dates within seven days of today. I suggest ...
user avatar
  • 16.6k
3 votes
Accepted

Pre-fill a cell with today's date

As mentioned by @Jacob Jan Tuinstra, TODAY updates automatically (so does NOW) and as I don't see the value of an entire column within which each cell always shows the current date, I interpret the ...
user avatar
  • 16.6k
3 votes

Pre-fill a cell with today's date

For todays date, you can use the following formula. Formula =TODAY() Explained The TODAY() formula provides the current date with no time component. It's better to use that, than to use the NOW() ...
user avatar
3 votes
Accepted

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

In cell D3 I owuld put the following formula: =if(EOMONTH($A1+70,0)=EOMONTH(D2,0),"Output","No report due") I assumed the $A1 to make sure that it works for all columns. The formula just compares ...
user avatar
3 votes
Accepted

Plus or minus quarters in Google Sheets using formulas

Using mid() extract the quarter portion of the original date, here after referred to as Q. Similarly extract the year portion, here after referred to as Y. The amount to be added will be referred to ...
user avatar
2 votes
Accepted

Date format in Google Spreadsheet is not correct

The solution is to set the correct Local under the Spreadsheet's settings ("This affects formatting defaults, such as currency."). So if you want US.locale style (MM-DD-YYYY), then choose US.Locale. ...
user avatar
  • 136
2 votes
Accepted

How can I use Google Spreadsheet to format Date in DD/MM/YYYY format?

This has now been resolved by Google Spreadsheets. Pasting in the date: 30/09/2013 21:15 And clicking Format > Number > Date time now immediately turns the cell into a date time cell (you can see ...
user avatar
2 votes

How can I search for Gmail messages on a particular date?

I put together a redirect for searching just 'back n days' that does the simple (and for me, most common use case) Writing a search for ‘inbox NOT including today’ is slightly counterintuitive and ...
user avatar
  • 489
2 votes

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

You can do it in a fairly ugly way by doing the full date formatting without the line break and then parse it out and add the line break in the formula. CHAR(10) doesn’t seem to work in the custom ...
user avatar
  • 1,814
2 votes

How to edit dates in Google Sheets as ISO 8601?

Partial answer According to https://en.wikipedia.org/wiki/Date_format_by_country, the following locales use YMD date format: Afghanistan, Albania, Bangladesh, Cambodia, Canada, China, People's ...
user avatar
  • 41.7k
2 votes
Accepted

Search Google with a date/time range

I believe you are asking how to perform a Google search with a time value flag on the search. This can be done by your program building its own search url. You likely already know that the searched ...
user avatar
2 votes

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

You can use this formula. Formula =ARRAYFORMULA(IF(ISBLANK(A2:A),"",A2:A + 7)) Screenshot Example I've created an example file for you: new date from entered date
user avatar
2 votes

Google Docs date capitalisation script

Change this var date = Utilities.formatDate(new Date(), "GMT", "ddMMMyyyy"); into this var date = Utilities.formatDate(new Date(), "GMT", "ddMMMyyyy").toUpperCase(); ht to Chris
user avatar

Only top scored, non community-wiki answers of a minimum length are eligible