I've tried fornatting, to no avail.......I'm on Excel '97. Cheers Nick
N Niek Otten Nov 10, 2006 #2 Hi Nick, Just subtract the oldest date from the newer one and format the result as General or Number, not Date. -- Kind regards, Niek Otten Microsoft MVP - Excel | I've tried fornatting, to no avail.......I'm on Excel '97. | | Cheers | | Nick | |
Hi Nick, Just subtract the oldest date from the newer one and format the result as General or Number, not Date. -- Kind regards, Niek Otten Microsoft MVP - Excel | I've tried fornatting, to no avail.......I'm on Excel '97. | | Cheers | | Nick | |
V vezerid Nov 10, 2006 #3 Nick, Simple subtraction will work. Excel stores dates internally as numbers. When one of the cells involved in an arithmetic operation has a certain format Excel often uses the same format for the output. You have two options: =B2-A2 and format the cell as general. Or, =VALUE(B2-A2) HTH Kostis Vezerides
Nick, Simple subtraction will work. Excel stores dates internally as numbers. When one of the cells involved in an arithmetic operation has a certain format Excel often uses the same format for the output. You have two options: =B2-A2 and format the cell as general. Or, =VALUE(B2-A2) HTH Kostis Vezerides
B bj Nov 10, 2006 #4 you could use =datedif(Date1,Date2,"d") datedif() is a useful function in EXCEL, but you won't find it in help
you could use =datedif(Date1,Date2,"d") datedif() is a useful function in EXCEL, but you won't find it in help
