Thread: Non Leap Years I want to show 28, leap years show 29 in an"IF"
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Duke Carey
 
Posts: n/a
Default 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
Reply With QuoteReply With Quote