I have people that have a set number of days for review time.
These need to be business days so the weekends dont' count. I have been trying but the math here is off.
so what I am trying to do is if someone starts class on 3-Jan and has 30 days for their review, what date do they end at. I got Feb 14th with this formula =B8+(C8+((C8/5)*2)) the issue is that when I did it in real-time it was like the fourth...
How can I fix this and account for leap years if excel doesnt.
Also I dont have access to the addin packs...
These need to be business days so the weekends dont' count. I have been trying but the math here is off.
so what I am trying to do is if someone starts class on 3-Jan and has 30 days for their review, what date do they end at. I got Feb 14th with this formula =B8+(C8+((C8/5)*2)) the issue is that when I did it in real-time it was like the fourth...
How can I fix this and account for leap years if excel doesnt.
Also I dont have access to the addin packs...