Hi,
I am stuck and would really appreciate if some one could help with creating a formula that recognises the date when it has been inserted into a cell using the today function.
I have a spread sheet that I want to have daily quotes updating automatically based on the today date. For example if A1 has the date using TODAY() and the date is 9/7/13 then the formula in b1 says if a1 is 9/7/13 then = c1, if a1 = 10/7/13 then = c2 and so on. Quotes could then be entered into the cells from C1 to C365.
Many thanks
Bookmarks