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

B

bob@toyota-lift

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
 
D

Duke Carey

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
 
R

Ron Rosenfeld

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
Click to expand...

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
 
B

bplumhoff

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
 
Top