New answers tagged google-sheets-dates
1
Yes. Clear the five cells where you want these column headers to go. Then place the following formula in the first of those five cells:
=SEQUENCE(1,5,2+"10/2/2021"+(INT((TODAY()-"10/2/2021")/7)*7))
Then select the five cells and change the format like this:
Format > Number > More Formats > Custom number format > dd mmm
The ...
0
Replace
=D1+10=IF(D1="12/30/1899","N/A","")
by
=IF(ISDATE(D1),D1+10,"N/A")
the above because :
including a = between D1+10 and IF will compare the results of the parts
Google Sheets, as other spreadsheet apps do, handle dates as serialized numbers displayed using number formatting settings, so comparing cell holding ...
0
Use trim(), to_text() or text() to turn the dateserial value returned by today() to a readable date, like this:
="Current Date: " & trim(today())
1
With the dates in A2:A9, use ifs() in an array formula like this:
=arrayformula(
regexreplace(
textjoin(
"", true,
ifs(
(A2:A9 <> A1:A8 + 1) * (A2:A9 <> A3:A10 - 1), trim(A2:A9) & ", ",
(A2:A9 = A1:A8 + 1) * (A2:A9 = A3:A10 - 1), "",
(A2:A9 = A1:A8 + 1), trim(A2:A9)...
Top 50 recent answers are included