+ Reply to Thread
Results 1 to 4 of 4

Need formula to calculate count of total team task month,week,day wise

  1. #1
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Need formula to calculate count of total team task month,week,day wise

    HI experts

    i have data task of employee A = 54000 between first quater jan to mar

    i want find count and average flow of month, week, and day flow of task?

    help me with formula calculation i simply did
    54000/3 for month,
    54000/4 for week
    54000/7 for day, but it doesnt work

    thanks

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Need formula to calculate count of total team task month,week,day wise

    Welcome to the forum

    Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

  3. #3
    Forum Contributor
    Join Date
    04-30-2013
    Location
    washington
    MS-Off Ver
    Excel 2019
    Posts
    168

    Re: Need formula to calculate count of total team task month,week,day wise

    hi sir please find the data in attachment
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,427

    Re: Need formula to calculate count of total team task month,week,day wise

    Perhaps the following will work:
    For month: =C2/3
    For week: =D2/4
    For day: =E2/7
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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] Formula to calculate the number of days between dates (month wise)
    By arun.sj in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-22-2019, 12:51 PM
  2. [SOLVED] calculate the duration Month wise ( total days in to period wise )
    By abuharvey in forum Excel General
    Replies: 4
    Last Post: 10-16-2018, 07:33 AM
  3. [SOLVED] Calculate a YTD Total based on Reporting Month and Week of Month via drop down selections
    By Miskondukt in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 03-02-2018, 05:14 PM
  4. Need to the Formula to get count in MOnth wise
    By KiranaW in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 07-07-2015, 02:58 AM
  5. Replies: 3
    Last Post: 01-16-2014, 02:12 PM
  6. [SOLVED] excel hlep to calculate the week no from dispatch to closed calls week wise
    By johnodys in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 09-05-2013, 04:53 AM
  7. [SOLVED] Formula to count entries as per month, year and submission wise
    By hanidean in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 05-26-2013, 11:52 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