View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ron Rosenfeld
 
Posts: n/a
Default 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