software

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 quot;b4quot; quot;b6quot; 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-gt;Add ins... and check Analysis
Toolpak

quot;bob@toyota-liftquot; wrote:

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

On Thu, 19 Jan 2006 10:17:02 -0800, bob@toyota-lift
gt; wrote:

gt;B3 contains the month
gt;b4 contains an if/or stmt for the last day of the month
gt;b5 is the year
gt;b6 contains an if/or stmt for the last day of the next month
gt;How can I get quot;b4quot; quot;b6quot; 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