Greg
10-30-2007, 04:19 AM
Hi all,
I have a Userform into which I insert dates to calculate the number of days between the two dates.
Until recently I thought this was working successfully. Indeed for some dates it does. For example if I enter a first date (12/12/2005) and a second date (12/12/2006) the correct number of days (365) is returned and used in an interest calculation on my document.
However, if I enter 07/04/2006 (i.e. 7 April 2004) and 30/10/2007 (i.e. 30 October 2007) I get 571 days. I have no idea why one set of dates will produce the correct answer and the other won't.
Does anyone have any suggestions?
Greg.
I have a Userform into which I insert dates to calculate the number of days between the two dates.
Until recently I thought this was working successfully. Indeed for some dates it does. For example if I enter a first date (12/12/2005) and a second date (12/12/2006) the correct number of days (365) is returned and used in an interest calculation on my document.
However, if I enter 07/04/2006 (i.e. 7 April 2004) and 30/10/2007 (i.e. 30 October 2007) I get 571 days. I have no idea why one set of dates will produce the correct answer and the other won't.
Does anyone have any suggestions?
Greg.