Determining number of dates held

's Computer Specifications

Hi,

I am using Excel 2002.
In column A I have a list of dates I purchased an item.
In column B I have the date it was sold.

How can I automatically calculate, in C, the number of days held?

I case it matters, the date format is dd/mm/yyyy

thanks

Daniel

's Computer Specifications

Sure, in C2, put something like:
=if(isblank(b2),"",b2-a2)
Copy it down.
Make sure C is formatted as numbers and not dates.
************
Anne Troy
www.OfficeArticles.com

"Daniel" <none@none> wrote in message
news:%(E-Mail Removed)...
> Hi,
>
> I am using Excel 2002.
> In column A I have a list of dates I purchased an item.
> In column B I have the date it was sold.
>
> How can I automatically calculate, in C, the number of days held?
>
> I case it matters, the date format is dd/mm/yyyy
>
> thanks
>
> Daniel
>

's Computer Specifications

Works well, thanks for your help

regards

Daniel
"Anne Troy" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Sure, in C2, put something like:
> =if(isblank(b2),"",b2-a2)
> Copy it down.
> Make sure C is formatted as numbers and not dates.
> ************
> Anne Troy
> www.OfficeArticles.com
>
> "Daniel" <none@none> wrote in message
> news:%(E-Mail Removed)...
>> Hi,
>>
>> I am using Excel 2002.
>> In column A I have a list of dates I purchased an item.
>> In column B I have the date it was sold.
>>
>> How can I automatically calculate, in C, the number of days held?
>>
>> I case it matters, the date format is dd/mm/yyyy
>>
>> thanks
>>
>> Daniel
>>
>
>

's Computer Specifications

You're welcome!
************
Anne Troy
www.OfficeArticles.com

"Daniel" <none@none> wrote in message
news:(E-Mail Removed)...
> Works well, thanks for your help
>
> regards
>
> Daniel
> "Anne Troy" <(E-Mail Removed)> wrote in message
> news:%(E-Mail Removed)...
>> Sure, in C2, put something like:
>> =if(isblank(b2),"",b2-a2)
>> Copy it down.
>> Make sure C is formatted as numbers and not dates.
>> ************
>> Anne Troy
>> www.OfficeArticles.com
>>
>> "Daniel" <none@none> wrote in message
>> news:%(E-Mail Removed)...
>>> Hi,
>>>
>>> I am using Excel 2002.
>>> In column A I have a list of dates I purchased an item.
>>> In column B I have the date it was sold.
>>>
>>> How can I automatically calculate, in C, the number of days held?
>>>
>>> I case it matters, the date format is dd/mm/yyyy
>>>
>>> thanks
>>>
>>> Daniel
>>>
>>
>>
>
>

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
DETERMINING NUMBER OF DAYS / MONTHS / YEARS BETWEEN TWO DATES	Boyertown Casket	Microsoft Excel Programming	1	17th Mar 2009 05:27 PM
Determining number of weeks between dates	goonboy175	Microsoft Excel Discussion	1	18th Jul 2005 09:17 PM
Determining the number of specific days between two dates in Excel	=?Utf-8?B?am9uIHM=?=	Microsoft Excel Worksheet Functions	9	21st Mar 2005 09:13 PM
Determining number of days between dates	=?Utf-8?B?RGViYmll?=	Microsoft Excel Worksheet Functions	4	20th Jan 2005 12:07 AM
Working with Dates: Calculating A Running Total for Days Held	Mcasteel	Microsoft Excel Programming	1	18th Nov 2004 07:09 PM