Previous Topic Next Topic

MS OFFICE EXCEL

Closed
lancymenezes Posts 3 Registration date Monday 12 November 2012 Status Member Last seen 16 November 2012 - 16 Nov 2012 à 05:13
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 - 16 Nov 2012 à 08:12
Hello,


HOW DO I FIX A FORMULA TO CHECK THE FOLLOWING:


IF YEAR "2012" AND MONTH "FEBRUARY" THEN NO. OF DAYS IS 29 OR ELSE 28.
FOR JANUARY, MARCH, MAY, JULY, AUGUST, OCTOBER AND DECEMBER THE NO. OF DAYS IS 31 AND FOR APRIL, JUNE, SEPTEMBER AND NOVEMBER THE NO. OF DAYS IS 30 IRRESPECTIVE OF LEAP YEAR OF NOT.

PLEASE ADVISE.

REGARDS,
LANCY MENEZES
MUMBAI
Related:

1 response

Réponse 1 / 1
Zohaib R Posts 2368 Registration date Sunday 23 September 2012 Status Member Last seen 13 December 2018 69
16 Nov 2012 à 08:12
Hi LANCY MENEZES,

To return the number of days in a month, use the following formula. Suppose cell A1 contains Feb-2012.

=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))

This will return 29, the number of days in February, 2012.

Please revert for clarification.