11 Replies Latest reply on Mar 1, 2017 7:16 AM by Shinichiro Murakami

    Weekly Average for last 5 business days and monthly average for last 30 business days

    Nat Vats

      I have attached a sample worksheet. In this worksheet dates are hardcoded for last 2 days average. I do not want to hardcode but calculate average based on last 5 business days(Weekdays) and monthly average based on last 30 business days.