Remember Me?

#1
March 15th 06, 06:07 PM posted to microsoft.public.excel.worksheet.functions
DAYS360 function for 365 day year

I need a function that will calculate the number of days between two dates.
The DAYS360() function does that, but assumes a 360 day year of 12 equal 30
day months. I need the function to assume a 365 day year using the actual
days in each month.

Can anybody help me?

Thanks.

#2
March 15th 06, 06:20 PM posted to microsoft.public.excel.worksheet.functions
 Big Rick Posts: n/a
DAYS360 function for 365 day year

Put date 1 in cell A1.
Put date 2 in cell A2
in A3 type =A2-A1
--
Big Rick

I need a function that will calculate the number of days between two dates.
The DAYS360() function does that, but assumes a 360 day year of 12 equal 30
day months. I need the function to assume a 365 day year using the actual
days in each month.

Can anybody help me?

Thanks.

#3
March 15th 06, 06:25 PM posted to microsoft.public.excel.worksheet.functions
 Niek Otten Posts: n/a
DAYS360 function for 365 day year

And then format as General or Number, not as date, which Excel does automatically.

--
Kind regards,

Niek Otten

"Big Rick" wrote in message ...
Put date 1 in cell A1.
Put date 2 in cell A2
in A3 type =A2-A1
--
Big Rick

I need a function that will calculate the number of days between two dates.
The DAYS360() function does that, but assumes a 360 day year of 12 equal 30
day months. I need the function to assume a 365 day year using the actual
days in each month.

Can anybody help me?

Thanks.

#4
March 15th 06, 07:25 PM posted to microsoft.public.excel.worksheet.functions
DAYS360 function for 365 day year

Thanks. I feel a little embarrased. It's almost too obvious and too easy.

Anyway, it worked. I appreciate the help.

"Big Rick" wrote:

Put date 1 in cell A1.
Put date 2 in cell A2
in A3 type =A2-A1
--
Big Rick

I need a function that will calculate the number of days between two dates.
The DAYS360() function does that, but assumes a 360 day year of 12 equal 30
day months. I need the function to assume a 365 day year using the actual
days in each month.

Can anybody help me?

Thanks.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Martin_London Excel Worksheet Functions 5 December 5th 05 11:20 PM mully New Users to Excel 4 May 23rd 05 11:56 AM Mark Excel Discussion (Misc queries) 5 May 12th 05 12:26 AM SVC Excel Worksheet Functions 9 February 28th 05 02:29 PM Robert AS Excel Worksheet Functions 4 December 2nd 04 10:49 AM

All times are GMT +1. The time now is 02:12 PM.