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