Long Date - Long Date = text is days

T

tom

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
 
E

Earl Kiosterud

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem formatting dates from CSV file 2
Determine if night shift by start & end time 2
Finding the right style field in VBA 0
Multiple IF's ?? 2
number of months and days between two dates without approximation 3
Need help 3
Checking for date and time overlaps 0
COUNT BETWEEN A SPECIFIC DATE RANGE 4

Top