Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date function
- Thread starter kitnba
- Start date
Paste the following into a standard code module: -
Function difference(value1 As Date, value2 As Date) As Integer
difference = DateDiff("d", value2, value1)
End Function
To use insert the following into a cell
=difference(datevalue 1, datevalue 2)
where datevalue is te date you wish to find the difference for
Function difference(value1 As Date, value2 As Date) As Integer
difference = DateDiff("d", value2, value1)
End Function
To use insert the following into a cell
=difference(datevalue 1, datevalue 2)
where datevalue is te date you wish to find the difference for
Or just = B - A
Dates are held as numbers in excel - and 1 day = 1
Therefore 1 hour = 1/24 etc etc so B-A will give you your answer in days
Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244
Dates are held as numbers in excel - and 1 day = 1
Therefore 1 hour = 1/24 etc etc so B-A will give you your answer in days
Rgds, Geoff
Si hoc legere scis, nimis eruditionis habes
Want the best answers to your questions ? - then read me baby one more time - faq222-2244
- Status
Similar threads
- Locked
- Question