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.

Please Login or Register  to view this content.

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.

hello
the real problems is in

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.

for the first one

Please Login or Register  to view this content.

these will meet your 3 criterias.
the second which is quoted is the next problem.
because we are using the today() function that will be changing every day
1 issue ** if b19 is equal today() =cell value is permanent

using copy paste special values i think is remedy ( macro??)
just giving some idea.

HTH