+ Reply to Thread
Results 1 to 1 of 1

Formula To Show Today's Sales Target, And Don't Update Until Tomorrow

  1. #1
    Registered User
    Join Date
    10-29-2019
    Location
    Birmingham, England
    MS-Off Ver
    Google Sheets
    Posts
    1

    Formula To Show Today's Sales Target, And Don't Update Until Tomorrow

    Hi all,

    I am creating a sales dashboard for my office with excel and Data Studio. What I would like to do is show the amount of sales required per day for the remaining days of the month which I have managed to do. The bit I'm struggling with is that my colleagues don't want it to update throughout the day.

    For example, if when we start the day we need to hit £1000 of sales to keep up on track, we would like it to stay at that figure until the end of the day rather than gradually decreasing as we get sales during the day. We only want it to update that figure the following morning (at which point it will have either gone up or down depending on if we hit the target or not)

    The problem is that if it updates during the day, the new figure is just the amount we need per day spread over the month rather than the amount we need today to keep us on track.

    I think what we need is something either in the source in excel that only calculates the values at a set time (say 8:00am) each day.

    Unless there's a better way to do this? I can see a few people have discussed sales dashboards here so maybe a solution already exists.

    Many thanks in advance!

    Richard
    Last edited by AliGW; 10-29-2019 at 05:44 AM. Reason: Moved to Google Sheeets section.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 10
    Last Post: 09-06-2023, 08:19 PM
  2. Slicer to filer by due date (EG Today, Tomorrow, This Week )
    By Ampedanarchist in forum Excel General
    Replies: 3
    Last Post: 03-01-2018, 12:19 AM
  3. Macro code to filter by today AND tomorrow
    By cmb80 in forum Excel General
    Replies: 3
    Last Post: 05-18-2017, 08:35 AM
  4. Conditional formatting for Today and Tomorrow
    By alipezu in forum Excel General
    Replies: 1
    Last Post: 01-24-2017, 02:03 AM
  5. [SOLVED] Excel 2013 already have Target GM % , wanst to add Target Sales Price
    By Bitto in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-15-2015, 10:25 AM
  6. [SOLVED] Make TODAY() not change tomorrow?
    By CSPENCER in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-22-2015, 06:54 PM
  7. Replies: 6
    Last Post: 09-29-2014, 12:35 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1