hi i am calculate the two dates difference and divided by 365 the out put is wrong
Please Login or Register to view this content.
one date is 11/10/2009
two date is 11/26/2009
diff= (two- one)/365
output is 0.0438 but it showing 4.38 why?
hi i am calculate the two dates difference and divided by 365 the out put is wrong
Please Login or Register to view this content.
one date is 11/10/2009
two date is 11/26/2009
diff= (two- one)/365
output is 0.0438 but it showing 4.38 why?
The number is being displayed in Scientific notation (the output is correct).
If you want to display to 2 decimals encase the output in a Format function, eg:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
thanks DonkeyOte
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks