+ Reply to Thread
Results 1 to 2 of 2

Nested IF/AND formula for Dates

  1. #1
    Registered User
    Join Date
    01-31-2022
    Location
    Mesa, AZ
    MS-Off Ver
    Office 365
    Posts
    46

    Nested IF/AND formula for Dates

    Hello,

    In a custom column I am trying to calculate if a dates is <= 10/1/2022 one date and >=12/31/2022 in the COP created column it will return a value of Q1-2023. I have tried #date(2022,10,1) and I am getting an error.

    Any assistance would be greatly appreciated.

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,463

    Re: Nested IF/AND formula for Dates

    Try:
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Time Difference between 2 dates as a decimal - nested in SUMIFS formula
    By ajwilltravel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 08-21-2022, 06:37 PM
  2. Nested formula that includes dates
    By Catdumana in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-11-2018, 11:44 AM
  3. Replies: 1
    Last Post: 02-15-2018, 03:56 AM
  4. [SOLVED] Nested If Functions for Upcoming Expiration Dates and Expired Dates
    By AmberLeanne in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 12-12-2017, 07:33 PM
  5. Replies: 12
    Last Post: 06-13-2014, 05:03 PM
  6. Help with nested IF formula to group dates
    By PRodgers in forum Excel General
    Replies: 3
    Last Post: 07-19-2009, 02:45 PM
  7. Replies: 3
    Last Post: 05-27-2009, 05:37 AM

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