Most valuable professional
  • Hot Topics

Excel Count Days in a Month

Dear all Could someone explain below formula to me please. Code: =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:

This article includes the following tags:

  • Excel
  • Microsoft Excel