Dear Friends,
I'm trying to calculate the rates for services where weekday & weekend rate is different (file attached). I cannot directly use NETWORKDAY function because of a difficult criteria given. For example, if I start on 1 March (Sunday) and Finish on 2 March (Monday), the rate is a Weekend rate and it's 1 day only. Unless I finish on 3 March, the rate is 1 Weekend & 1 Weekday.
After trying for 2 long days, I thought I got the answer but the formulas worked only for March. When i test for April, the calculation is wrong again. Any thoughts what am I missing? Thanks.
- Ichigo
Bookmarks