Results 1 to 6 of 6

Date in column header won't work in formula

Threaded View

  1. #1
    Registered User
    Join Date
    01-27-2015
    Location
    houston, texas
    MS-Off Ver
    Excel 2010
    Posts
    6

    Date in column header won't work in formula

    I've built an amortization table and have dates as column headers.
    1/1/2019, 2/1/2019, 3/1/2019,...

    In another table I have Start Date and End Date columns. I've built a formula that essentially says, =IF(AND(1/1/2019 is > Start Date, 1/1/2019 < End Date),"TRUE", "")

    So if it's between the start and end date I want a "TRUE" result.

    This formula works fine when I have my data in just a range. (as you'll see in the file).
    The second I turned that range into a table the formula gave me a false reading (because the dates in the column headers are now acting as TEXT and not DATES, despite me changing the format to date).

    How can I fix this or workaround it?

    See file attachment.
    Attached Files Attached Files
    Last edited by canefan17; 10-20-2019 at 03:39 AM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Deleting column based on Column header date less than today
    By daryl83 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-20-2017, 02:44 PM
  2. Replies: 7
    Last Post: 04-01-2016, 03:27 PM
  3. [SOLVED] how to make my one row macro work on the entire column, also have header on row 1
    By dmcgov in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 01-28-2016, 12:19 PM
  4. Replies: 2
    Last Post: 03-03-2014, 10:56 AM
  5. Combine multiple columns into one column with header and date in another column
    By JJadams in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 11-12-2012, 05:30 PM
  6. Finding a column value based on date and column header
    By soready42012 in forum Excel General
    Replies: 0
    Last Post: 01-18-2012, 06:21 PM
  7. Replies: 2
    Last Post: 04-10-2006, 03:40 PM

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