Results 1 to 7 of 7

Need to Calculate First 10 days for data

Threaded View

  1. #1
    Registered User
    Join Date
    08-18-2017
    Location
    India
    MS-Off Ver
    Excel 2010
    Posts
    62

    Need to Calculate First 10 days for data

    Hi,

    NEED AN URGENT HELP!

    I have a data for last 30 days in excel with dates - I need to count first 10 days records, then 2nd 10 Days records & then 3rd Days of records.
    But I do not want to give Start date & End date in formula. So when ever I update the record it should calculate as per the given dates in excel.

    Example :
    A2:A90

    Formula used - =COUNTIFS(A2:A91,">="&TODAY()-37) which counts total records from today i.e. 90 records
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Calculate Uptime in Days within the constraint of Total Days in Each Month
    By jchungerford in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 04-29-2017, 06:54 PM
  2. Formula to automatically calculate after a data has passed 90 days
    By cardonas in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-16-2016, 03:39 PM
  3. [SOLVED] calculate total number of days between two days based on 365 days year
    By aparunkumar in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 03-14-2016, 12:51 AM
  4. Replies: 0
    Last Post: 06-11-2015, 03:12 AM
  5. Calculate and Sum Data based on Days Worked
    By rviji.cbe in forum Excel Formulas & Functions
    Replies: 25
    Last Post: 05-30-2015, 08:26 PM
  6. Calculate total working days and excepted leave days
    By megaiooo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-21-2013, 09:29 AM
  7. How to calculate my inventory days when I have the consumption Data
    By Pravesh in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-17-2012, 05:40 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