Results 1 to 7 of 7

Sorting "" properly for date formatted column

Threaded View

  1. #1
    Registered User
    Join Date
    10-31-2013
    Location
    Your, Basement
    MS-Off Ver
    Excel 2013
    Posts
    6

    Sorting "" properly for date formatted column

    Having an issue with sorting dates properly.

    Formula in each cell of column P is:
    =IF(O6="","",INT(O6)+120)

    *have also tried
    =IF(ISBLANK(O6),"",INT(O6)+120)

    The issue is when filtering column P I can only sort a-z as opposed to oldest to newest

    Ran test on it [ =ISTEXT(P6) ] and find that if there is a date in it result is false and if not, "" returns as True.

    So the issue is that Excel sees the blank "" as text and tries to filter accordingly. Is there a solution to this or am I stuck with 1/1/1900 instead of blanks if I want to be able to filter properly?
    Last edited by TheGunslinger; 05-06-2015 at 04:32 PM. Reason: edited for clarity

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Date Format "d-mmm-yy" as Worksheet Name does not sort properly
    By tv69 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 12-13-2013, 03:35 PM
  2. [SOLVED] If there is any text in column "A$" on "sheet1" then move cell to column "A$" on "sheet2"
    By ckgeary in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2013, 08:28 PM
  3. Format(date,"mm/dd") returns date formatted as "mm-dd"
    By MenacingBanjo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-16-2013, 09:15 AM
  4. In Excel a cell formatted "currency" shows "######" help!
    By llveda in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-07-2006, 04:40 PM
  5. [SOLVED] Excel shouldn't ***** about a "date format" when formatted as txt
    By Ibbits in forum Excel General
    Replies: 5
    Last Post: 07-18-2005, 01:05 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