Skip to main content
9 votes

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

You can insert the vertical tab unicode character U+000b You can copy and paste it from between these brackets: ] [
ninjagecko's user avatar
6 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/...
metarmask's user avatar
  • 161
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. ...
alex sichwart's 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()
pnuts's user avatar
  • 17.7k
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. ...
Ludable's user avatar
  • 381
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 ...
Franck Dernoncourt's user avatar
4 votes

Difference between today and a date with negative numbers

Have you tried substracting both values? You could format it as number if it shows like a date in year 1899.
Martín's user avatar
  • 1,386
4 votes

How to get Sheets to recognize dates that are entered without any separators?

One approach might be to use one column formatted as plain text to enter the dates in yyyymmdd format, then use an array formula in another column to generate the dates in the correct format. For ...
The God of Biscuits's 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 ...
Jared Pinkham's 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
ePandit's user avatar
  • 139
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 ...
pnuts's user avatar
  • 17.7k
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 ...
mhoran_psprep's user avatar
2 votes

How to make Google Sheets jump to closest date to today when opened?

I was able to piece together a solution thanks to the help of @Rubén who provided the elements. Perhaps there is a more elegant solution (with a single formula?), but this working for me. This ...
user196554's user avatar
2 votes

Google Docs date in yyyy/mm/dd format (year first)

I did not realize there was a "Format > Number > More formats > More date n Time formats" where I could specify the exact format I want, since the default date format is not what I am looking for. It ...
Cyril Duchon-Doris's user avatar
2 votes

How to add every Sunday in sequential order with 3 blank cells under each date?

Solution with a Formula : A1 : =ArrayFormula(if( mod(ROW(A1:A100),4)=1, text((round(ROW(A1:A100)/4)*7)+43730,"dddd dd mmm yy") ...
pjmg's user avatar
  • 2,010
2 votes

How to get Sheets to recognize dates that are entered without any separators?

You can format those numbers so that they look like 2023-12-03 like this: Format > Number > Custom number format > 0000-00-00 That will not convert the values to dates, though. The underlying ...
doubleunary's user avatar
  • 14.9k
2 votes

How to get Sheets to recognize dates that are entered without any separators?

You can enter numbers as numbers... Enter 20231225 in A1, and in an adjacent cell, add the following formula. =DATE(A1/10000, MOD(INT(A1/100),100), MOD(A1,100)) If your dates are all in this century, ...
Fe2O3's user avatar
  • 151
1 vote
Accepted

Date highlighting of a cell, separated by weeks, given only a starting date and a cell range

You will need to delete all formulas in spacer cells in row 2 and then use this custom formula: =IF(D2=WEEKNUM(TODAY(),2),1) or for the whole column: =IF(D$2=WEEKNUM(TODAY(),2),1)
user0's user avatar
  • 26.7k
1 vote

How can I display Google Sheets dates as Month-Day with the underlying data in UTC format (YYYY-MM-DD)?

Just change the format by going to Format >Number >More Formats >More date and time formats and choose or create the one that meets your needs.
marikamitsos's user avatar
  • 12.9k
1 vote

I wrongly set the date of 2000 cells. I want to add 20 years of those cells. How?

Try using the EDATE() formula. Since it adds months you'll need 240. Something like this: =ARRAYFORMULA(EDATE(A2:A2000,240)) Then paste values. Alternatively, you could use this formula: =...
Oleg_S's user avatar
  • 791
1 vote

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

Assume that you have 31 sheets, named 1 to 31 respectively. This script works when the spreadsheet is opened by using a simple onOpen trigger. new Date(): gets today's date now.getDate(); is a ...
Tedinoz's user avatar
  • 5,741
1 vote

Time until Specified Date

In case it's useful, I was able to get the desired output with the below code and updated the output to be in Years, Days and Hours instead. Others can use the pluralized names to get their desired "...
mitchell-reynolds's user avatar
1 vote
Accepted

How to validate a date in Google Forms?

In contrary to Short text, paragraph and checkbox questions, Google Forms doesn't have a way to validate input through date questions. Ref. Set rules for your form There is no way to add client-side ...
Rubén - Volunteer Moderator -'s user avatar
1 vote

Format Google Analytics Date

You need to use TEXT, instead of TO_TEXT: =TEXT('90diaspessoas'!A16,"dd-mm-yyyy" ) As long as underlying date number is correct, This will work. OR Set formatting in '90diaspessoas'!A16 ...
TheMaster's user avatar
  • 3,342
1 vote

Look for today() in range D5:AP5 is X in the range D8:AP8

Please try: =IF(SUMPRODUCT(--(D5:AP5=TODAY());--(D8:AP8="X"))=1;"Ok","Not OK") SUMPRODUCT
pnuts's user avatar
  • 17.7k
1 vote
Accepted

How to sort Trello cards by date added

Trello support tells me: This isn't possible natively, but there's a popular Chrome extension that does allow for this: Ultimello I've since downloaded the extension, and it seems to do the job. ...
samthebrand's user avatar
  • 5,459

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