General information
Category:
Coding, syntax & commands
Thanks ! It has given a idea. But actually when I proceed further I find that my problem is different.
I have tried to work with the help provide by you. For calculating months and days the help is ok. But while I was trying to solve the problem relating to banking I
failed to find the exact result. By using help of you & Vladimir Zografski
I am getting different results.Let me consider them one by one.
Rich Pupko Vladimir Zograski
month Days Month Days
d1=(12/01/2005) 11 31 0 364
d2=(11/01/2006)
if d2=(12/1/2006) 11 32 0 365
if d2=(13/1/2006) 12 2 0 366
but where
d1=(12/12/2004)
d2=(12/03/2006) 14 29 3 365
But in our banking system we simply count one year for the period from (1201/2005) to (12/01/2006) and (12/01/2006) is the payment date.
For the given last period the period of deposit is one year 3 months or 15 months.Please help me.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only