Excel Forum
Similar Content
6 Tricks to Make Dates Work in Excel
Tutorial: Watch this tutorial if you work with dates! Quick and easy ways to reliably convert dates...
Naming Cells in Excel to Make Using Formulas/Functions Easier
Tutorial: In this tutorial I am going to introduce the idea of Named Cells. A Named Cell is a cell w...
Logical Comparison Operators in Excel - How to Compare Things
Tutorial: (Video tutorial's page: Compare Values in Excel - Beginner to Advanced) Logical compariso...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Magic Trick 470: Formula For Days In Any Given Month


Days in Any Given Month Excel 2007 / 2010 Formula

=DAY(EOMONTH(TODAY(),0))

Days in Any Given Month Excel 2003 7 before Formula

=DAY(DATE(YEAR(TODAY()),MONTH(TODAY())+1,0))





Got a Question? Ask it Here in the Forum.