Excel Forum



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.