Find Today's Date function

**qbrg** · 06-19-2012, 01:03 AM

Hi everyone, thank you in advance for your help. I hope I can explain this clearly enough to get a response.

I have a spreadsheet with column A - all dates. Column B is a numerical value. I want to be able to enter in today's value in one cell at the very top of the spreadsheet, and have it automatically entered next to today's date in column B. For example, if today (6/18/12) I entered in the number 500 in the one cell at the top, I want it to automatically enter the numerical value 500 next to 6/18/12 in column B below. Tomorrow (6/19/12) I want to be able to enter a different number, let's say 550, in the one cell at the top, and have it automatically entered next to 6/19/12 in column B below. I want the previous day's value to remain unchanged.

Any suggestions??

Thanks again!

**Fotis1991** · 06-19-2012, 01:51 AM

Hi

With your list of dates starting in A2 and your number that you want in B1, try this in B2 and copy down.

=IF(A2=TODAY(),$B$1,"")

**qbrg** · 06-20-2012, 02:35 PM

Thank you for your help fotis. Your suggestion is very close to working!! The only problem that I came across was when it becomes tomorrow (lets say tomorrow is 6/21), the value in column B for (6/20) will disappear since 6/20 is no longer 'today'. Do you know a way to keep the previous day's values using your formula without losing the values for each previous day?
Thanks again!