+ Reply to Thread
Results 1 to 4 of 4

If problems

  1. #1
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    If problems

    I have had a ton of help here today so thanks to all.
    this is my last issue.

    three columns
    "D" Order Date...date invoice was entered
    "E" Measure date...date measure was actually done
    "F" Anticipated measure date...Date 14 days after "A"

    If "E" when entered is past the date in "F" I need for nothing to happen.
    if "E" when entered is within the 14 day period i need "F" to show nothing

    In F currently is the following:
    =if(d4=0,"",d4+14) date in F stays no matter what

    I tried in F the following:
    =if(E4>D4,D4+14,D4)
    although the above works how do I make the date clear if the date is before that entered in E?
    Thanks
    Southwest Granite & Glass
    Quality, It's what we do
    http://www.swgg.ca

  2. #2
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: If problems

    I'm not quite sure I follow. What should happen if E4=D4?

    A date can be less than, equal to or greater than another date.

    Some possibilities

    =if(E4>=D4,D4+14,"")

    =if(e4>d4,d4+14,if(e4=d4,d4,""))

  3. #3
    Forum Contributor
    Join Date
    12-13-2009
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2007
    Posts
    149

    Re: If problems

    =if(D4=0,"",D4+14) in column F
    this works like i want it to giving me the automatic 14 days out. When i enter a date into column e i need the date in column f to disappear if the date entered is before that in f?
    Last edited by mojobaabby; 12-13-2009 at 07:38 PM.

  4. #4
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: If problems

    sheesh, can you upload a workbook? that would be so much easier to understand.

+ 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