What does this formula return?
=FILTER(
SEQUENCE(365;1;DATE(YEAR(TODAY());1;1));
WEEKNUM(SEQUENCE(365;1;DATE(YEAR(TODAY());1;1)))<>WEEKNUM(SEQUENCE(365;1;DATE(YEAR(TODAY());1;1))+1))

Question

What does this formula return? 
 
=FILTER( 
 
SEQUENCE(365;1;DATE(YEAR(TODAY());1;1)); 
 
WEEKNUM(SEQUENCE(365;1;DATE(YEAR(TODAY());1;1)))<>WEEKNUM(SEQUENCE(365;1;DATE(YEAR(TODAY());1;1))+1))

Answer

One date for each week of the year

Answer

A list of leap years

Answer

A list of weekend dates for the year

Answer

A sum of values by week

Crowdly

What does this formula return? =FILTER( SEQUENCE(365;1;DATE(YEAR(TODAY());...

Want instant access to all verified answers on moodle.essec.fr?