+ Reply to Thread
Results 1 to 4 of 4

Add an expire date

Hybrid View

der1ross Add an expire date 02-25-2014, 07:07 AM
windy58 Re: Add an expire date 02-25-2014, 08:03 AM
der1ross Re: Add an expire date 02-25-2014, 09:27 PM
windy58 Re: Add an expire date 02-26-2014, 05:26 AM
  1. #1
    Registered User
    Join Date
    02-25-2014
    Location
    bc canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Add an expire date

    the formula I have used to date is
    =LOOKUP(I3,{0,25,250},{"1 Jan 2014","1 Jan 2014","Never"})

    What this has done for me is that when I enter $25 in I5 the formula would enter the expire date of 1 Jan 2014 and that was ok until we changed our membership expire dates.
    Now a member can sign up say... on March 1, 2014 for 25 dollars but I cannot figure out the formula to expire one year hence considering for instance that if we have 12 members who all sign up on different months how would you write a formula to change individually each sign up dates based on the amount (0,25,250) in I5.
    I have an excel database I can attach if that might help to clarify

    Thanks for this

  2. #2
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: Add an expire date

    How about just adding 365 to the signup date using an if/or statement

    =IF(OR(B1=0,B1=25),A1+365,"Never")

    Windy

  3. #3
    Registered User
    Join Date
    02-25-2014
    Location
    bc canada
    MS-Off Ver
    Excel 2003
    Posts
    4

    Re: Add an expire date

    Windy
    Thank you... Works very well indeed. My mind was obviously in park and looking for something much more complicated.

  4. #4
    Forum Contributor
    Join Date
    03-17-2005
    Location
    Canterbury, Kent
    MS-Off Ver
    2003, 2010
    Posts
    285

    Re: Add an expire date

    Glad to have been of help.

    Windy

+ 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. Msgbox before booking date expire
    By JAHBLI in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-25-2013, 02:45 AM
  2. [SOLVED] email when cell date expire
    By laduk in forum Outlook Formatting & Functions
    Replies: 4
    Last Post: 10-28-2012, 01:10 PM
  3. COUNTIF date will expire in a date range
    By neilanderson in forum Excel General
    Replies: 6
    Last Post: 07-31-2012, 02:08 PM
  4. [SOLVED] Date Function:contracts expire.
    By LisaS in forum Excel General
    Replies: 1
    Last Post: 07-27-2005, 04:05 PM
  5. Check Expire Date
    By kuanct in forum Excel General
    Replies: 5
    Last Post: 02-24-2005, 11:22 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