7 Replies Latest reply on Oct 13, 2013 6:35 PM by Shawn Wallwork

    Hi there, I am struggling to build a formula (I'm a beginner)...

    Nicholas Abbott

      Hi there, I am struggling to build a formula ('m a beginner)...I need the formula to be a range of "days" that counts the number of sales made for each day eg: Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday. Currently, I have this formula: ZN([Last Weeks Count]) - LOOKUP(ZN([Last Weeks Count]), -1), however, this formula is giving me info from "last week", I need it to provide info from the days specified. CAN YOU PLEASE HELP ME???!!!