69
You can use the before and after keywords in your search, for example:
after:2012/4/26 before:2012/5/3
To search for emails between April 26, 2012 and May 3, 2012.
28
In the right hand side of the gmail search bar there is a drop-down arrow- click it.
The drop-down includes a date range option, and you should be all set from there
6
You can do the formatting on the fly:
=text(B2,"m/d/yyyy")&C2
Google Sheets Help: TEXT()
5
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. You can also reverse it:
sort list "X" by time in list descending
You can apply the command at certain times, e.g.:
every day at 6am, sort list "X" by time ...
4
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://drive.google.com/settings
4
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 date. The current date minus the specified date equals the days passed between the dates.
The code above means "If D2 is not empty set current cells value to ...
4
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.
Instruction:
Select cell A1
Go to Format/Conditional Formatting
Below "Format cells if..." choose "Custom formula is"
type: =DATEDIF(A1,TODAY(),"D")>10
4
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 options:
Then you can change the date format:
3
This can be achieved with the built-in developer tools of the browser. They can be used to input any value as a custom number format, including text with newlines and tabs.
Start adding a custom number format.
Press F12 to open the developer tools.
Select the console tab.
Paste the following text into the console:
Object.defineProperty($("[label='...
3
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 a Conditional formatting Custom formula is of the type:
=and(A1>today()-7,A1<today()+7)
where six days before today, today and six days after today ...
3
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 requirement to be for a non-volatile solution. Hence suggest:
Ctrl+;
in the cell starting a new row. For such cells to be populated with the same result ...
3
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() formula. This will update on every edit made to the sheet, see reference.
Note
Please realize that the value returned by the TODAY() formula isn't permanent. ...
answered Oct 28 '14 at 14:50
Jacob Jan Tuinstra
21.2k16 gold badges88 silver badges183 bronze badges
3
Formatting is not the answer, because it doesn't affect the underlying values. You need to make the values updatable instead.
One way is to make a reference-data place somewhere in one of your sheets (or maybe add a new sheet just for that), and put the year value in there.
Then in the first cell where you want the date values to appear, use this ...
3
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 particular post, including all the comments.
All you need to then do is look for the comment you're interested in and then go to the first <published> that ...
answered Jul 19 '14 at 4:02
Eight Days of Malaise
15.4k6 gold badges53 silver badges87 bronze badges
3
Use this to add the dates:
Code
function onEdit(e) {
var aCell = e.source.getActiveCell(), col = aCell.getColumn();
if(col == 2 || col == 4 || col == 6) {
var adjacentCell = aCell.offset(0, 1);
var newDate = Utilities.formatDate(new Date(),
"GMT+1", "dd/MM/yyyy kk:mm:ss");
adjacentCell.setValue(newDate);
}
}
Example
I've ...
3
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 the end of the month in the second row with the end of the month for the date in cell a1 + 70 days.
If the date is 1/1/2017 then 70 days later is 3/12/2017, so ...
3
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 as D.
To get the new quarter add D to Q and modulo by 4. This will be correct except it will equal 0 when it should be 4. Wrap this whole portion in an if() to ...
2
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. If you are in a different locale and want formatting
2
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 this as it adds seconds).
2
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
2
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 formatting nor does \n.
Assuming your date is in cell A1 and set to read Saturday, October 31, 2015 (which is one of the defaults)
You can break it down and ...
2
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
Change this
var date = Utilities.formatDate(new Date(), "GMT", "ddMMMyyyy");
into this
var date = Utilities.formatDate(new Date(), "GMT", "ddMMMyyyy").toUpperCase();
ht to Chris
answered Jan 29 '15 at 18:09
Jacob Jan Tuinstra
21.2k16 gold badges88 silver badges183 bronze badges
Only top voted, non community-wiki answers of a minimum length are eligible
