+ Reply to Thread
Results 1 to 3 of 3

date functions:specific text.

  1. #1
    Registered User
    Join Date
    07-05-2011
    Location
    Cincinnati, OH
    MS-Off Ver
    Mac Excell 2011
    Posts
    10

    date functions:specific text.

    I have a date in cell b1, I need cell b4 to look at b1 and if it is over 15 days put in specific text. I also need it to go out 21 days and put in different text and same for 7 days. I used this for 15 days.=IF(E3>=TODAY()-15,"","Submitted 15+ Days"). My problem is no matter what I try I can not get any other days to work. Any help would be greatly appr. Thanks

  2. #2
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,167

    re: date functions:specific text.

    Hi jmendenhall22 and welcome to the forum,

    I understand part of this question but not all of it. See if the attached helps?
    Attached Files Attached Files
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

  3. #3
    Registered User
    Join Date
    07-05-2011
    Location
    Cincinnati, OH
    MS-Off Ver
    Mac Excell 2011
    Posts
    10

    Re: date functions:specific text.

    Marvin,
    Thank you for the response, it worked. I have not been on for awhile and forgot to post. Thank you again it worked for what I needed.
    John

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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