| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
DOnt calculate leap year
I need a formula that counts leap years as 365 days instead of 366 days. My work sheet is set up as follows: c10=6/6/2003 f10=06/15/2003 h10=f10-c10 c13=6/15/2003 f13=6/6/2004 h13=f13-c13 i need the sum of h10 and h13 to always equal 365 even if it is a leap year other things that may help you understand this worksheet: c9=prior anniversary date f9=calculation date h9=low days c12=calculation date f12=next anniversary date h13=high days and i need high days and low days to always equal 365 i need excel to never calculate a february 29 -- kckar ------------------------------------------------------------------------ kckar's Profile: http://www.excelforum.com/member.php...o&userid=25322 View this thread: http://www.excelforum.com/showthread...hreadid=387998 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do we calculate T-bill Price in 365 days year. | Excel Worksheet Functions | |||
| How to compare current year to prior year in bar chart? | Charts and Charting in Excel | |||
| leap year question | Excel Discussion (Misc queries) | |||
| how do i calculate principal payed in one year in excel | New Users to Excel | |||
| calculate negative or positve difference in time | Excel Discussion (Misc queries) | |||
Threaded Mode
