+ Reply to Thread
Results 1 to 6 of 6

i need help with IF function with date

  1. 07-09-2018, 03:22 AM #1
    bkcffee
    bkcffee is offline
    Registered User
    Join Date
    10-13-2016
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    84

    i need help with IF function with date

    hello

    i need lil help with IF function... my A column has dates from June to July
    i need to make IF Cell A date in June month, then Vlookup etc etc,,, if NOT false


    thanks in advance
    Reply With QuoteRegister To Reply
  2. 07-09-2018, 03:26 AM #2
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,188

    Re: i need help with IF function with date

    So something like this:

    =IF(MONTH(A2)=6,VLOOKUP(...),FALSE)
    Ali

    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
    NB:     as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.
    Reply With QuoteRegister To Reply
  3. 07-09-2018, 03:31 AM #3
    bkcffee
    bkcffee is offline
    Registered User
    Join Date
    10-13-2016
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    84

    Re: i need help with IF function with date

    excellent !!!
    ty Alison !!
    Reply With QuoteRegister To Reply
  4. 07-09-2018, 03:38 AM #4
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,188

    Re: i need help with IF function with date

    It's Ali.

    Gald to have helped. If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Reply With QuoteRegister To Reply
  5. 07-09-2018, 04:22 PM #5
    bkcffee
    bkcffee is offline
    Registered User
    Join Date
    10-13-2016
    Location
    Kuwait
    MS-Off Ver
    2016
    Posts
    84

    Re: i need help with IF function with date

    eek,, sorry,, thought its a shortform for Alison :x
    my bad... ty again
    Reply With QuoteRegister To Reply
  6. 07-09-2018, 04:50 PM #6
    AliGW
    AliGW is offline
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2505 (Windows 11 Home 24H2 64-bit)
    Posts
    91,188

    Re: i need help with IF function with date

    It is, but only my mother calls me Alison.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. date function not working.....if date blank says its a valid date
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 05-23-2018, 09:25 AM
  2. [SOLVED] Function to randomly output date/time between to fixed date/times
    By 160998 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-17-2018, 02:49 AM
  3. Vlookup function, date selection issue (nearest date before and after certain date)
    By Vend1301 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-16-2015, 08:57 AM
  4. Automating out current loan period from start date and todays date in IMPT function
    By rpratt21 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-12-2014, 11:37 AM
  5. [SOLVED] Function/formula to compare and insert todays date or yesterdays date
    By TC922 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-17-2013, 05:28 AM
  6. a function to find the previous date based on a given date and a range of dates
    By scott.s.fower in forum Tips and Tutorials
    Replies: 0
    Last Post: 05-30-2013, 07:50 PM
  7. Function that will create a range based on a start date and end date
    By ckosman in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-24-2013, 10:09 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1