Skip to Content
0
Former Member
May 16, 2005 at 10:33 AM

Calculating the No of days....

17 Views

Hi All,

In my sales report, I need to calculate % time.

The user inputs a date and I need to calculate %Time as:

%TIME= Days lapsed upto that selected date in the month in which the selected date is present/total No of days in that month.

This formula is valid if the selected date is in the current month. If the selected date is not in current month:

%TIME = 100%

Can anyone tell me how to achieve this?

Thanks in advance

Vinay