Conditional Confusion w/dates and IF?

[maloneyman]

This is the 4th forum I've posted my cry for help on this problem.Here it is....

I am trying to create a workbook where the first sheet is an INPUT sheet.

The INPUT sheet will be where each day my secretary will be able to open it, it will display the current date and below have areas where she can record the Time in, Time out, and sales each day for each employee.

The other sheets are to be monthly records of the results from INPUT. I have each workday listed in columns with the "datevalue" of that day. I want to know how I can create a formula that will check the current date and if it matches the value in the cell that has the same datevalue it will record the data from INPUT into the cell next to the date. which I have managed to make happen. my question is how do I KEEP that value in the cell. the very next day since the datevalue changes every formula I have tried changes my value from the day before back to zero or blank.


is there hope out there?

 

[Luke M]

You won't be able to do it with formulas alone. You'll need to use a macro somehow, either to record the data initially (and skip the formulas), or to somehow force the formulas to become a value at the end of the day, when you essentially want to "freeze" the records.


Alternatively, does your company have Microsoft Access? That would probably be more ideal, as you could design a form that autoloads with today's date (just like your current INPUT sheet), but each record would be saved in a table.

 

[NARAYANK991]

Hi ,


Is it possible you can upload your workbook on some file sharing website and post the link here so that we can take a look at it ?


Narayan