I want to count the days backwards starting from today. But I want to the cells to fill in with the date (xx/xx/xxxx). Is there a formula that I can use that will start with today and then I can drag that down so it will have the previous day and so forth? I want my spreadsheet to look like this
example:
a1 = 06/08/2012
b1 = 06/07/2012
c1 = 06/06/2012
Keep in mind that I only want it to display workdays so dates for Monday through Friday. Any help would be great. Thanks.
Bookmarks