| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Arithmatic functions with date format...angry results
Can anyone tell me how to do the following:
I have a col. A and Col b with dates in the following format: 12/5/2008 12:00:00 AM and 11/19/2008 0:00 What I need to make a formula in the next col that will tell me how many days apart these two dates are. Basically, just need to subtract the two dates and display the number of day between the two dates.. Any thoughts on how to do this? Thanks a bunch for all the help!! -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200901/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Using intermediate results in Worksheet functions | Excel Worksheet Functions | |||
| Created IF functions - Need sum of results | Excel Worksheet Functions | |||
| Database Functions - Strange results | Excel Worksheet Functions | |||
| Text Time Coversion Arithmatic | Excel Discussion (Misc queries) | |||
| functions are not displaying the results | Excel Worksheet Functions | |||
Threaded Mode
