LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 4
Default DAYS360---How come the days do not add up to be 360?

I applied the DAYS360 function to each month of 2007, and the result is not
30 days for each month. In fact each 31-day month turned out to have an
output of 30 days, each 30-day month has an output of 29, and Feb has an
output of 27. It added up to 353 days for the year using each month's output.
However when I use 1/1/2007 and 12/31/2007 as my start and end date, the
function indeed gives 360 days. I am very perplexed. Could anyone help,
please???
 
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
DAYS360 Candentco Creative Collection[_2_] Excel Worksheet Functions 4 April 12th 07 09:48 PM
DAYS360 Trouvera52 Excel Worksheet Functions 1 January 2nd 07 06:25 PM
=DAYS360 Owen Excel Discussion (Misc queries) 1 February 15th 06 03:30 PM
Days360 problem jellorain Excel Worksheet Functions 6 February 10th 06 05:22 PM
DAYS360 Jan Buckley Excel Worksheet Functions 3 July 21st 05 10:44 PM


All times are GMT +1. The time now is 10:13 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"