I need to show dates from May 1, 2013 through yesterday's date. Yesterday will be dynamic, since each new day they open the spreadsheet we'll show the date filled in for the "new yesterday." Any help?
I need to show dates from May 1, 2013 through yesterday's date. Yesterday will be dynamic, since each new day they open the spreadsheet we'll show the date filled in for the "new yesterday." Any help?
A1 = May 1, 2013
A2 =IF(TODAY()-1>A1,A1+1,"")
A3 =IF(TODAY()-1>A2,A2+1,"")
etc.
Willem
English is not my native language sorry for errors
Please correct me if I'm completely wrong
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks