Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Query

  1. #1
    Board Regular
    Join Date
    Apr 2002
    Posts
    63
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I want to write an array formula which will compare two dates.
    Eg : I have a range of dates in cells A3:F3
    i want to see whether the month and year entered by the user exists in cell A3:F3

    [ This Message was edited by: sree_31 on 2002-04-24 07:52 ]

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    84,038
    Post Thanks / Like
    Mentioned
    37 Post(s)
    Tagged
    7 Thread(s)

    Default

    On 2002-04-19 01:05, sree_31 wrote:
    I want to write an array formula which will compare two dates.
    Eg : I have a range of dates in cells A3:F3
    i want to see whether the month and date entered by the user exists in cell A3:F3
    Lets say that A1 houses the date entry by the user in true date format:

    =COUNTIF(A3:F3,A1)>0

    will return TRUE if the entry exists in the target range, otherwise FALSE.


Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •