Generate List of Dates between two Dates By Excel Functions
=TEXTSPLIT(
TEXTJOIN(
",",
TRUE,
MAP(
C6:C9,
D6:D9,
LAMBDA(a, b,
TEXTJOIN(
",",
TRUE,
TEXT(
SEQUENCE(
b - a + 1,
,
a,
1
),
"dd" & "/" & "mm" & "/" &
"yyyy"
)
)
)
)
),
,
","
)
ليست هناك تعليقات:
إرسال تعليق