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:
- Microsoft Excel