Results 1 to 2 of 2

Conditional Confusion w/date functions

Threaded View

  1. #1
    Registered User
    Join Date
    11-08-2011
    Location
    nevada, usa
    MS-Off Ver
    excel 2010
    Posts
    1

    Exclamation Conditional Confusion w/date functions

    Wow, I'm really stumped.....any help is truly appreciated.

    I've created a very useful workbook.

    I have so far only one problem.
    I am trying to find out how to create a formula using the IF function that will return true if the condition is met. and if not met I want it to not change the date that is present in the cell.

    this may help get my concept across.
    =IF(19=TODAY(),INPUT!G7,+IF(B19<TODAY(),+IF(B19>TODAY(),,)))
    My thinking was/is wish it could be.....
    The red text is the condition to be met in order to return true.
    The Green text is the data to return from the input sheet if the condition is met/true.
    The purple text is where I am trying to make no changes to the cell data since B19 "is less than" TODAY().
    The yellow test is where again..I am trying to make no changes to the data since B19 "is greater than" TODAY().

    You see ideally the idea is each day of work has a position in the monthly sheets for the data input from the input sheet. once TODAY(), is equal to each date, the data input will be placed in the correct cell. problem is the next day since TODAY() no longer is equal to the previous day this formula pulls the data out and inserts the current in the next leaving the previous day blank. I don't want to lose the data from the previous entries.

    can anybody help. is there some syntax that will cause a condition to do nothing to my data if greater than or less than?

    maloneyman
    Obviously, my thinking was that if I put nothing in between the commas then nothing would happen. wrong. it blanks the cell.
    Last edited by pike; 11-08-2011 at 02:22 AM. Reason: remove colour

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