Results 1 to 8 of 8

Next date after Today()

Threaded View

  1. #1
    Registered User
    Join Date
    12-19-2008
    Location
    CA
    Posts
    64

    Next date after Today()

    What I'm trying to accomplish:

    In A1:
    If a date in H2:H10 is greater than TODAY(), return the value of that date.

    If TODAY() happens to be 1/20 and H2:H10 looks like this:

    1/5/09
    1/6/09
    1/13/09
    1/14/09
    1/19/09
    1/15/09
    1/22/09
    1/27/09
    1/8/09
    1/28/09


    than A1 should have the value of 1/22/09
    When TODAY() = 1/28/09, A1 should have no value, preferably no error either, but I can live with a NUM! or Value! or #N/A

    Dates will not always be ascending. All cells in H2:H10 may not be filled. There may possibly be a duplicate, but the fact that there is a duplicate is not important to my result. (I'm looking for the 'next scheduled working day' whatever it is)
    Last edited by Lizabeta; 01-21-2009 at 08:36 PM. Reason: Edit: To Solved status... 2nd Edit:Noticed some baaad grammer

Thread Information

Users Browsing this Thread

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

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