filmov
tv
Check IF the Year is a LEAP in Excel #shorts
![preview_player](https://i.ytimg.com/vi/wIMAlJXXq5E/maxresdefault.jpg)
Показать описание
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
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