How to Determine the 3 of days between two dates

's Computer Specifications

Have to determine the number of days between two dates

exmple: 1/1/98 and 3/31/98 = #days

Thanks
--
Helping Is always a good thing

's Computer Specifications

one way is to use the Int() worksheet function.
A1: 1/15/2007
A2: 1/30/2007
B2: = INT(A2-A1)

Merjet

's Computer Specifications

If in different cells, simply subtract one from the other

--
Don Guillett
SalesAid Software
(E-Mail Removed)
"QuietMan" <(E-Mail Removed)> wrote in message
news:42D72942-6663-417E-9278-(E-Mail Removed)...
> Have to determine the number of days between two dates
>
> exmple: 1/1/98 and 3/31/98 = #days
>
> Thanks
> --
> Helping Is always a good thing

's Computer Specifications

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Steps to determine # of days between dates	Stefanie	Microsoft Access Getting Started	4	4th Mar 2009 06:05 PM
Conditional Formatting Dates calculating 10 days and 30 days from a certain date	Sioux	Microsoft Excel Worksheet Functions	2	11th Oct 2007 02:04 PM
Determine dates by number of days, "what date is 180 days from now	=?Utf-8?B?VFJMYW1i?=	Microsoft Outlook Calendar	2	19th Apr 2007 03:30 PM
Calculation to determine days between two dates	=?Utf-8?B?RHVibGVhYQ==?=	Microsoft Excel Worksheet Functions	3	17th Mar 2005 03:27 AM
Range of dates determine days	=?Utf-8?B?RE5TTklERVI=?=	Microsoft Excel Worksheet Functions	2	24th Dec 2004 03:07 AM