Excel Date Problem

[DuMoore]

I need Excel to return the number of days in a month based on a date entered by a user. For example: if a user enters 12-12-02, then I need Excel to return 31.

Is there a way to accomplish this? I have tried to split the date into columns then read the first 2 digits, and then relate that number to a HLOOKUP table holding the number of days in a month. That idea worked very poorly.

Any and all help would be greatly appreciated.

 

[Dreamboat]

Days In Month

To return the number of days in a month, use the following formula. Suppose cell A1 contains the date 15-Jan-1998.

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

This will return 31, the number of days in January, 1998.

From Chip Pearson's site:

http://www.cpearson.com/excel/DateTimeWS.htm

Anne Troy

http://www.TheOfficeExperts.com

 

[onedtent]

if date is in cell A3

=EOMONTH(A3,0)-EOMONTH(A3,-1)

 

[SkipVought]

btw, EOMONTH is an Add-In. Skip,
SkipAndMary1017@mindspring.com

 

[Dreamboat]

Hey!!!!

Welcome back, Skip! Anne Troy

http://www.TheOfficeExperts.com

 

[DuMoore]

Thanks a lot guys!!!!