| Home |
| Search |
| Today's Posts |
|
#6
|
|||
|
|||
That is because the dd will only go up to 31, then it cycles back to 1. Been
caught by that myself <vbg -- HTH Bob Phillips "Paul Sheppard" wrote in message news:Paul.Sheppard.1rfruc_1120129521.3682@excelfor um-nospam.com... Hi Greg That worked ok for the example I gave, but when I use future dates that are months away I do not get the result I would expext eg Future Date 09/09/2005 08:54 Now 30/06/2005 11:23 Result 10:21:03 The hours and minutes look ok but not the days?????? -- Paul Sheppard ------------------------------------------------------------------------ Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783 View this thread: http://www.excelforum.com/showthread...hreadid=383463 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculating with dates | Excel Discussion (Misc queries) | |||
| calculating with dates | Excel Worksheet Functions | |||
| Calculating differences between dates | Excel Worksheet Functions | |||
| Calculating dates | Excel Discussion (Misc queries) | |||
| Calculating Due Dates Based on Payments | Excel Worksheet Functions | |||
Threaded Mode
