» Finding the Number of Days in a Given Month
CATEGORY - Excel Date & Time Formulas
VERSION - All Microsoft Excel Versions
Calculating the number of days in each of the months listed in column A, for the year specified in column B.
Solution:
Use the DAY and DATE functions as shown in the following formula:
=DAY(DATE(B2,A2+1,0))
Book Store:
Recommended Books:
- Financial Peace: Revisited
- Marketing Management
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
- Adventure Capitalist: The Ultimate Road Trip
- Windows XP Pocket Reference
- Managing by the Numbers: A Commonsense Guide to Understanding and Using Your Company's Financials: An Essential Resource for Growing Businesses
No comments have been submitted.
