Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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/ |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Calculating total number of days in rolling year | Excel Worksheet Functions | |||
Calculating the days between two dates | Excel Worksheet Functions | |||
Calculating total number of days | Excel Worksheet Functions | |||
Conditional Formatting Dates calculating 10 days and 30 days from a certain date | Excel Worksheet Functions | |||
Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) |