Results 1 to 3 of 3

Thread: Need a formula to compare month and year

  1. #1
    Seeker Emanuel Levy's Avatar
    Join Date
    Jan 2013
    Location
    Toms River, New Jersey, United States
    Posts
    19
    Articles
    0

    Need a formula to compare month and year



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I looked at http://www.excelguru.ca/content.php?...standing-Dates and can't figure out how to check if the date in a cell is equal to the current month and year. I know how to see if this moth is greater than or equal to a month in another cell but that doesn't work if the date in the other cell is from a prior yer,

  2. #2
    Hi Emanuel Levy
    How about if you put it in a AND function.
    =AND(MONTH(A1)=MONTH(TODAY()),YEAR(A1)=YEAR(TODAY()))

  3. #3
    Try


    =TEXT(A2,"mmyyyy")=TEXT(TODAY(),"mmyyyy")

Posting Permissions

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