How to calculate days in the month

[shanmer]

Hi,

I would like to find a function that can calculate the number of days in the month for a given date that is provided in the following format dd/mm/yy.

For example 23/02/02, would result in 28.
23/02/04, would result in 29.
31/01/01, would result in 31.
etc....

Thanks in Advance,
Sharon

[Aladin Akyurek]

On 2002-03-11 21:03, shanmer wrote:
Hi,

I would like to find a function that can calculate the number of days in the month for a given date that is provided in the following format dd/mm/yy.

For example 23/02/02, would result in 28.
23/02/04, would result in 29.
31/01/01, would result in 31.
etc....

Thanks in Advance,
Sharon

Sharon,

One way:

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

where A2 house a date like the examples you provided.

Aladin

[Ivan F Moala]

Looks like Alladin beat me to it just
as I was about to post

Just to add to that format the cell as
general....

Ivan

[Russell Hauf]

On 2002-03-11 21:03, shanmer wrote:
Hi,

I would like to find a function that can calculate the number of days in the month for a given date that is provided in the following format dd/mm/yy.

For example 23/02/02, would result in 28.
23/02/04, would result in 29.
31/01/01, would result in 31.
etc....

Thanks in Advance,
Sharon

If you have the Analysis ToolPpak add-in installed (Tools-Add-ins, Analysis ToolPak if you don't), you can use the following formula:

=EDATE(A1,1)-A1

This assumes your date is in A1.

Hope this helps,

Russell