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.
...
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()
- 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/...
- 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. ...
- 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://...
- 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 ...
- 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 ...
- 14.8k
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 ...
- 15.8k
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
- 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 ...
- 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 ...
- 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() ...
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 ...
- 7,094
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 ...
- 517
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. ...
- 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 ...
- 257
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 ...
- 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 ...
- 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 ...
- 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 ...
- 1,705
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
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
Only top scored, non community-wiki answers of a minimum length are eligible