Excel Forum
Similar Content
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...
Manually Calculate Formulas and Functions in Excel
Tutorial: How to force Excel to recalculate all formulas and functions without editing or entering ...
Logical Comparison Operators in Excel - How to Compare Things
Tutorial: Logical comparison operators allow you to compare values in Excel to see if they are equal...



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.