LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
bob@toyota-lift
 
Posts: n/a
Default Non Leap Years I want to show 28, leap years show 29 in an"IF"

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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
DATEDIF and leap years Leyland New Users to Excel 2 July 21st 05 07:49 PM
Show quarters and years on x axis of a chart Kacee Charts and Charting in Excel 3 March 19th 05 03:42 AM


All times are GMT +1. The time now is 07:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"