Results 1 to 2 of 2

Thread: How to use multiple criteria using IF 360DAYS & today() functions in one formula???

  1. #1

    How to use multiple criteria using IF 360DAYS & today() functions in one formula???



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

    Hi all, first time poster - just wondering if anyone is able to help me correct the below formula please?
    What I need is a formula that will:
    a) calculate the number of days overdue a task is,
    b) if a task is due within 60 days from today, display the message "Due",
    and c) if a task is due in more than 60 days from today, display the message "Not Past Due".

    I've got this, which is working kind of:
    =IF(DAYS360(J3,TODAY())<-61,"Not Past Due",IF(DAYS360(J3,TODAY())>-61,"Due",DAYS360(J3,TODAY())))

    The issue is it doesn't give a numerical value of days overdue in the cells that are overdue, it just automatically says "Due".

    Can anyone figure out how to do this?

    Thank you in advance
    Last edited by tori14; 2015-05-28 at 09:05 AM. Reason: more info

  2. #2
    Conjurer hossat's Avatar
    Join Date
    May 2015
    Location
    Algiers, Algeria
    Posts
    114
    Articles
    0
    Excel Version
    365
    Hi


    try this formula =IF(DAYS360(J3,TODAY())<61,"Not Past Due","Due")&" "&DAYS360(J3,TODAY())
    Good luck

Posting Permissions

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