Excel: Count Days in a Month


Dear all Could someone explain below formula to me please.

=DAY(DATE(YEAR(A1),MONTH(A1)+1,1)-1)
The red parts, no idea. Thank you very much


This question generated 9 answers. To proceed to the answers, click here.

This thread is current as of May 24, 2015.


For more resources for Microsoft Excel