+ Reply to Thread
Results 1 to 4 of 4

Counting Date Fields

  1. #1
    Forum Contributor
    Join Date
    03-30-2008
    Posts
    121

    Counting Date Fields

    Column A contains dates formated 07/15.

    I would like to construct a formula for column B that would count
    the number of days since the date posted in column A.

    For example, today is 07/27, therefore the answer would be 12.

    Hopefully someone can point me in the right direction --- I don't even
    know where to start other than =Count( .

    Help is always appreciated.

  2. #2
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    ...

    In B1: =TODAY()-A1
    formatted as number
    //Ola

  3. #3
    Forum Contributor
    Join Date
    03-30-2008
    Posts
    121

    Counting Date Fields / A Complication

    The formula In B1: =TODAY()-A1 formatted as number works perfectly.

    However, there is another problem. When I tested the formula I realized that there are two fields with dates. A1 and B1 --- either can contain a date but not both at the same time. C1 would then contain In B1: =TODAY()-A1 formatted as number, however, it needs to consider both A1 and B1.

    Thanks for everyone's help.

  4. #4
    Forum Expert
    Join Date
    12-24-2004
    Location
    Sweden
    Posts
    1,256

    ...

    "either can contain a date but not both at the same time"

    ...can contain...
    =CHOOSE(1+ISNUMBER(A1)*1+ISNUMBER(B1)*2,"",TODAY()-A1,TODAY()-B1,"")

    ... always contain...
    =TODAY()-IF(ISNUMBER(A1),A1,B1)


    HTH
    Ola

+ 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