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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
Back
Top