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

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

Post by Ym9iQHRveW » Sat, 21 Jan 2006 03:17:02


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"

Post by RHVrZSBDYX » Sat, 21 Jan 2006 03:26:03

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

 
 
 

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

Post by Ron Rosenf » Sun, 22 Jan 2006 02:39:48

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



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"

Post by bplumhof » Sun, 22 Jan 2006 05:25:12

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