» Finding the Last Day of a Given Month
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Problem:Calculating the date at the end of the current month, as well as the date at the end of each month (serial number) listed in column A.
Solution:
To calculate the date at the end of the current month, use the EOMONTH and TODAY functions as shown in the following formula:
=EOMONTH(TODAY(),0)
To calculate the date at the end of next month, use the EOMONTH and TODAY functions as shown in the following formula:
=EOMONTH(TODAY(),1)
To calculate the date at the end of each month listed in column A, use the DATE function as shown in the following formula:
=DATE(2005,A2+1,0)
Book Store:
Recommended Books:
- Seven Habits Of Highly Effective People
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Analysis of Financial Statements
- Quantitative Methods in Derivatives Pricing: An Introduction to Computational Finance
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- AWAKEN THE GIANT WITHIN : HOW TO TAKE IMMEDIATE CONTROL OF YOUR MENTAL, EMOTIONAL, PHYSICAL AND FINANCIAL
No comments have been submitted.
