Hi there I'm trying to use the DAYS360 function in Excel to calculate the time between two dates, but stupidly have only just realised that it counts the year as twelve months of exactly 30 days. Is there any way I can alter this function, or use another function, to do a correct calculation. I have just entered 26 October 2004 in one cell and 1 November 2004 in another, and it thinks this is a distance of 5 days where it should be six. All help very gratefully received. Jeremy

Excel already knows how to calculate using dates. From Excel Help - DAYS360: Quote Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months. End Quote Are you not wanting to calculate 30 day months for the reasons above? If not then don't you the function. In Excel, when you input a date it doesn't see it as a date but as a value. 26-Oct-04 is seen as the numeric value of 38286 which is how many days have elapsed since 31-Dec-1899. 1-Nov-04 is 38292. So just do the math on the cells (no function needed). B2-A2=6 Bryan

I've also used workdays in excel quite well, best way I found to use the days function is to test it based on the answer you expect and adjust the formaula accordingly.