Currently, I'm stuck in calculating the total days from 2 dates.
Let say I have *Startdate in A1*, *Enddate in B1* and the *total days
in C1*, how would I write it in VBA?

I tried using the formulas in the cells like below:

eg: Start Date=15.Nov.03 ; Enddate=30.Dec.03

in Cell C1:
=Day(B1)-Day(A1)
This gives me *16.Jan.00* as the answer!!

Plz help! thx!!


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/