+ Reply to Thread
Results 1 to 3 of 3

Help in Formula

  1. #1
    Registered User
    Join Date
    11-28-2012
    Location
    lebanon
    MS-Off Ver
    Excel 2010
    Posts
    73

    Lightbulb Help in Formula

    Hello,
    I need help in this formula please.

    file attached name: New Microsoft Excel Worksheet (2).xlsx
    I need to mention in status
    if the validity date is greater than itself than its invalid
    if the validity date is between issuing date and itself (validity date) than its valid.
    if the issuing date will become close to the validity date so status will mention risky

    thanks for help
    Attached Files Attached Files

  2. #2
    Forum Contributor arlu1201's Avatar
    Join Date
    09-09-2011
    Location
    Bangalore, India
    MS-Off Ver
    Excel 2003 & 2007
    Posts
    19,166

    Re: Help in Formula

    Please take a moment to read the forum rules and then amend your thread title to something descriptive of your problem. Once you have done this please send me a PM and I will remove this request.

    To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.
    If I have helped, Don't forget to add to my reputation (click on the star below the post)
    Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code: [code] Your code here [/code]

  3. #3
    Forum Contributor dogberry's Avatar
    Join Date
    07-15-2012
    Location
    Wales, UK
    MS-Off Ver
    Excel 2010
    Posts
    624

    Re: Help in Formula

    Hi

    "if the issuing date will become close to the validity date so status will mention risky"

    When you change your thread title as requested can you also define what you mean by the above statement Ive already done the first two bits for you but cant post at the moment.

    Chris
    Click my star if I helped Thanks

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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