ammartahir1978
asked on
excel formula
I want to know the formula for :
if i have 10 days and my start date is 26/09/2016 i want to know how many days i am in for 10 days considering weekend.
so 10days starts from 26/09/2016, on 27/09/2016 my cell should say i am 10% in of my 10 days.
thanks for your help
if i have 10 days and my start date is 26/09/2016 i want to know how many days i am in for 10 days considering weekend.
so 10days starts from 26/09/2016, on 27/09/2016 my cell should say i am 10% in of my 10 days.
thanks for your help
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi Ammar,
Please see sample file attached with example formula
Please see sample file attached with example formula
ASKER
Perfect thank you
attached
PercentageDaysFormula.xlsx
PercentageDaysFormula.xlsx
Just checked, you may have to adjust the result by 1 day:
=(NETWORKDAYS(C3,TODAY(),H olidays)-1 )/D3
I forced the entries to be 26/9 and 27/9 and it gave difference of 2 (or 20%).
Thanks
Rob
=(NETWORKDAYS(C3,TODAY(),H
I forced the entries to be 26/9 and 27/9 and it gave difference of 2 (or 20%).
Thanks
Rob
If you want to allow for holidays as well, set up the holidays in a list and then use:
=NETWORKDAYS(C3,TODAY(),Ho
Thanks
Rob H