Check IF the Year is a LEAP in Excel #shorts

preview_player
Показать описание
Check IF the Year is a LEAP Year in Microsoft Excel

Method 1: =IF(MONTH(DATE(YEAR(C7),2,29))=2=TRUE,"Leap","Regular")

Method 2: =IF(MOD(YEAR(C18),4)=0,"Leap","Regular")

HAPPY NEW YEAR 2024
Рекомендации по теме