Non Leap Years I want to show 28, leap years show 29 in an"IF"

B3 contains the month
b4 contains an if/or stmt for the last day of the month
b5 is the year
b6 contains an if/or stmt for the last day of the next month
How can I get "b4"+"b6" to know when its a leap year

You could just use

=eomonth(B4,1) to get the last day of the next month

Requires the Analysis Toolpak ... Tools->Add ins... and check Analysis
Toolpak

"bob@toyota-lift" wrote:

> B3 contains the month
> b4 contains an if/or stmt for the last day of the month
> b5 is the year
> b6 contains an if/or stmt for the last day of the next month
> How can I get "b4"+"b6" to know when its a leap year

On Thu, 19 Jan 2006 10:17:02 -0800, bob@toyota-lift
<bob@toyota-lift@discussions.microsoft.com> wrote:

>B3 contains the month
>b4 contains an if/or stmt for the last day of the month
>b5 is the year
>b6 contains an if/or stmt for the last day of the next month
>How can I get "b4"+"b6" to know when its a leap year

From what you write, it's hard to tell what you are doing.

Perhaps if you give examples of your data and formulas, we could better assist.


--ron

Hi Bob,

write into B4:
=DAY(DATE($B$5,$B$3+1,0))

and into B6:
=DAY(DATE($B$5,$B$3+2,0))

HTH,
Bernd