Long Date - Long Date = text is days
 

In a worksheet I am trying to subtract a long date format from a long date
format and trying to return the days between the two dates.

example: 10/13/2006 8:30:00 AM - 9/6/2006 10:04:00 AM

TFTH,
Tom

Long Date - Long Date = text is days
 

Tom,

Just subtract them. = B2-C2 (or whatever). Excel will happily format the
cell for date, which is meaningless in this context (a date minus a date
ain't a date), so change the formatting to General or number.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"tom" wrote in message
...

In a worksheet I am trying to subtract a long date format from a long date
format and trying to return the days between the two dates.

example: 10/13/2006 8:30:00 AM - 9/6/2006 10:04:00 AM

TFTH,
Tom

Long Date - Long Date = text is days
 

Thanks I figured it out after I sent the posting...
Thanks again!

"Earl Kiosterud" wrote:

Tom,

Just subtract them. = B2-C2 (or whatever). Excel will happily format the
cell for date, which is meaningless in this context (a date minus a date
ain't a date), so change the formatting to General or number.

--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"tom" wrote in message
...

In a worksheet I am trying to subtract a long date format from a long date
format and trying to return the days between the two dates.

example: 10/13/2006 8:30:00 AM - 9/6/2006 10:04:00 AM

TFTH,
Tom