Calculate the # of days in a Month?

[AllenRitch]

Is there an easy way to calculate the number of days in a month or range of months? The NETWORKDAYS formula doesn't include the weekends and the DAYS360 formula is based on 360 days. I need it to be based on a 365 day calendar year (i.e. actual days).

 

[SkipVought]

Hi,
[tt]
=date(year(maxdate), month(maxdate)+1, 0)-date(year(mindate), month(mindate), 1)+1
[/tt]


Skip,
[sub]
[red]Be advised:[/red] The dyslexic, agnostic, insomniac, lays awake all night wondering...
"Is there really a DOG?" [/sub]