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!