datedatetimeif-statementgoogle-sheetsstring-formatting
Why does making this Google Sheets formula an ARRAYFORMULA change it's behavior?
This formula works on a per-row basis:
=(IF(today()-D2 > 365,text(D2:D,"mmm yyyy"),text(D2:D,"mmm d")))
But if I make it an ARRAYFORMUAL like below it always returns text(D2:D,"mmm yyyy") even when today()-D2 > 365 is False.
=arrayformula(IF(LEN(D2:D) = 0, "", (IF(today()-D2 > 365,text(D2:D,"mmm yyyy"),text(D2:D,"mmm d")))))
See screenshot below. Column D is the source date. Column F is the ARRAYFORMULA. Column G is the standard formula (hard-coded per row vs ARRAYFORMULA).
I want the ARRAYFORMUAL in column F to replicate the result in column G.
Solution
try:
=ARRAYFORMULA(IF(LEN(D2:D), IF((TODAY()-D2:D)>365,
TEXT(D2:D, "mmm yyyy"), TEXT(D2:D, "mmm d")), ))
- Get the Month from a date string
- Wrong Date returning
- Java day of the week from string
- Add/Subtract months/years to date in dart?
- Creating a new Date object or using setter methods of javascript Date()
- mixed date converted from default mm/dd/yy in excel to dd/mm/yy
- Why dec 31 2010 returns 1 as week of year?
- validate the credit card expiry date using java?
- Calculate weeknumber from a date value
- How to auto insert Current DATE in SQL with Java / Hibernate
- JavaScript date objects UK dates
- reverse date javascript from yyyy/mm/dd to dd/mm/yyyy
- Joda Time get date from Year + WeekOfYear + DayOfWeek
- Count the number of inclusive dates covered by a date period
- convert mysql timestamp into actual date and time?
- How to find week of the month
- How to convert a string to date in MySQL?
- Filter dataframe by nearest date
- How to calculate the first Monday of the month; python 3.3+
- Java Date Conversion
- Java Converting String(day/month/year) format to Date
- Convert dateTime to date in dd/MM/yy format in java
- how to get dateformat to capitalize month and day
- Matching multiple number rows and check corresponding dates within 90 days
- Why does converting "year + week number + weekday number" always return January 25 for all weeks and weekdays when using %V?
- JavaScript, get date of the next day
- Calculate average days between dates continuously updating
- what is a fractional second?
- How do I format a date in JavaScript?
- Does the yyyymmdd.hhmmss date time-format have a name?