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