+ Reply to Thread
Results 1 to 4 of 4

Formula Assist

Hybrid View

  1. #1
    admin@wyomingcallcenter.com
    Guest

    Formula Assist

    I am trying to come up with a formula or macro that would take a column
    of various dates and compare the amount of days between each date and
    the current date. If the amount of days for any of those cells is =|>
    183 give me a count of the number of cell that meet this parameter. Not
    sure where to start with this one any help would be greatly appreciated.


  2. #2
    Forum Contributor
    Join Date
    06-01-2006
    Posts
    324
    Assuming Column A is your dates,
    Put this in Colum B, =Today()-A1
    make sure Column B is formated General

    then put =COUNTIF(B:B, ">183")
    Google is your best friend!

  3. #3
    Forum Contributor
    Join Date
    06-01-2006
    Posts
    324
    Assuming Column A is your dates,
    Put this in Colum B, =Today()-A1
    make sure Column B is formated General

    then put =COUNTIF(B:B, ">183")

  4. #4
    Valued Forum Contributor tony h's Avatar
    Join Date
    03-14-2005
    Location
    England: London and Lincolnshire
    Posts
    1,187
    To get the number of days difference you just need to subtract one date from another. then use a countif to get the total you want.

    if you only want weekdays use networkdays(date1,date2)

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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