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

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

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

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

On Thu, 19 Jan 2006 10:17:02 -0800, 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

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

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

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