CHRISTMAS_EXCITEMENT. It estimates the % of excitement about Christmas.
=LAMBDA([Date],
LET(Date, IF(ISOMITTED(Date), TODAY(), Date),
NextChristmasEve, DATE(YEAR(Date + 6), 12, 24),
DaysToChristmasEve, NextChristmasEve - Date,
Excitement, MIN(MAX((30 - DaysToChristmasEve) / 30, 0), 1),
Excitement))
ليست هناك تعليقات:
إرسال تعليق