+ Reply to Thread
Results 1 to 7 of 7

Average Dispatch per Month

  1. #1
    Registered User
    Join Date
    01-07-2024
    Location
    United Arab Emirates
    MS-Off Ver
    MS Office 2019 (Newbie & Learning)
    Posts
    25

    Average Dispatch per Month

    Hi community,
    Good day!

    Having some trouble with formula on calculation average dispatch per month on the attached sheet.
    Please be kind enough for landing the average dispatch per month quantity on the column given.


    Thanking and appreciate the support.
    Attached Files Attached Files

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Average Dispatch per Month

    What's the EXPECTED result? You've left the cell empty.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  3. #3
    Registered User
    Join Date
    01-07-2024
    Location
    United Arab Emirates
    MS-Off Ver
    MS Office 2019 (Newbie & Learning)
    Posts
    25

    Re: Average Dispatch per Month

    Hi AliGW,

    I need the result on the empty cell as below;

    The expected result should be;
    Average Quantity dispatched per month till date (the total dispatched quantity is already there, receipt date is also there) so from date of receipt till now average dispatched per month.

    I hope you got it?

    Thanks

  4. #4
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Average Dispatch per Month

    No - I asked you for your EXPECTED result. What would that be? I need a manually calculated value, please. You ought by now to know that you should always provide manually calculated expected results in your sample files.

    I'll offer ONE guess only:

    =G3/DATEDIF(F3,TODAY(),"m")
    Last edited by AliGW; 02-07-2024 at 05:53 AM.

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Average Dispatch per Month

    Is this solved?

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,869

    Re: Average Dispatch per Month

    Seen, gone, no response.

  7. #7
    Registered User
    Join Date
    01-07-2024
    Location
    United Arab Emirates
    MS-Off Ver
    MS Office 2019 (Newbie & Learning)
    Posts
    25

    Re: Average Dispatch per Month

    Hi AliGW,

    Thank you for solving it and apologies for delay in reply.
    Closing the thread.

+ 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. [SOLVED] Rolling 12-month average, multiple entries per month
    By markrc139 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 01-24-2021, 09:32 PM
  2. Multiple vehicle dispatch
    By nsbstokes in forum Excel General
    Replies: 3
    Last Post: 01-27-2020, 08:05 AM
  3. Want Pivot table's average to show average by number of month.
    By jp16 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-16-2019, 06:07 AM
  4. dispatch cell for all combination
    By actarus123 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-23-2017, 04:07 AM
  5. Formula for average duration for each month based on the ending month
    By bobby769 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 07-21-2013, 11:18 AM
  6. Replies: 4
    Last Post: 05-24-2013, 01:24 PM
  7. Conditional Format-Dispatch
    By stevekirk in forum Excel General
    Replies: 4
    Last Post: 03-30-2007, 06:03 AM

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