Re: How do I obtain number of days in the month of a given date
From: Ron Rosenfeld (ronrosenfeld_at_nospam.org)
Date: 10/14/04
- Next message: Ron Rosenfeld: "Re: How do I count cells in Excel between date values?"
- Previous message: Frank Stone: "RE: Work*** views"
- In reply to: Robert: "How do I obtain number of days in the month of a given date"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 14 Oct 2004 08:01:44 -0400
On Thu, 14 Oct 2004 00:17:02 -0700, Robert <bobbell@discussions.microsoft.com>
wrote:
With the given date in A1:
If you have the analysis tool pak installed, you can use:
=DAY(EOMONTH(A1,0))
If you do NOT have the ATP installed, then you can use:
=DAY(DATE(YEAR(A1),MONTH(A1)+1,0))
--ron
- Next message: Ron Rosenfeld: "Re: How do I count cells in Excel between date values?"
- Previous message: Frank Stone: "RE: Work*** views"
- In reply to: Robert: "How do I obtain number of days in the month of a given date"
- Messages sorted by: [ date ] [ thread ]
