Question

Hola Excel Exprtz!

Here's the que in the attachment.

Answer 1

Answer:

=IF(MONTH(DATE(YEAR(A1),2,29))=2,TRUE,FALSE)

Explanation:

=IF(MONTH(DATE(YEAR(A1),2,29))=2,TRUE,FALSE)

option A just miss =

This is the right answer

As Date function returns date  ( Year , Month , Date)

so DATE(YEAR(A1),2,29)

will return date 29-Feb of Year in Cell A1

Now month return the number as  Jan = 1 , Feb = 2 & so on

if it will be a leap year then 29-Feb will exist in that year

so Month will return output 2

2 = 2

Hence TRUE

if it will not be a leap year then 29-Feb will not exist in that year

so Month will not return output 2 ≠ 2

Hence FALSE

=IF(MONTH(DATE(YEAR(A1),2,29))=2,TRUE,FALSE)

Answer 2

HI BRO...

YOUR ANSWER IS HERE IN THE ATTACHMENT

THANK YOU..!!!