Dates Formula

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Dates Formula

  1. #1
    Board Regular gymwrecker's Avatar
    Join Date
    Apr 2002
    Location
    Fort Knox, KY
    Posts
    323
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Dates Formula

     
    =IF(TODAY()-A1>30,"LATE","DUE") Note: This is the formula in A2

    Now, I need the following:

    A2 be blank only when the date in A1 is not within 30 days from today; once it falls within those 30 days, it will start showind as "DUE".

    In other words: I'm working with reports that are due 30 days out from when they expire (A1 in this case). If the report is over 30 days, then it is a "LATE" report. Now, reports that are not within the 30 days, they're not either late or due, they are OK. Thanks for your help!!!!

  2. #2
    MrExcel MVP DRJ's Avatar
    Join Date
    Feb 2002
    Location
    California
    Posts
    3,853
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    =IF(TODAY()-A1>=30,"LATE",If(TODAY()-A1>=0,"DUE",""))

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
  •  

 

 
DMCA.com