Excel formula?

1 ⤊

What do I enter in Excel if I want the cell to autopopulate the date for the last working day? So say today is Monday and if I want today's date to show up, I will type =today(). But if I want Friday's date to show up, what formula do I need to enter in the cell? Thanks!

2006-11-12 21:49:41 · 2 answers · asked by number_n 2 in Computers & Internet ➔ Software

I want the formula to be constant. So if I opened the spreadsheet tomorrow it should automatically be able to calculate the date for today. So today()-3 will not work. I don't want to change the formula everyday.

2006-11-12 22:00:32 · update #1

2 answers

=WORKDAY(TODAY(),-1)

You will need to add the Analysis ToolPak add-in if you get a #NAME error

2006-11-13 00:35:15 · answer #1 · answered by O Caçador 6 · 1⤊ 0⤋

=today()-3

2006-11-12 21:54:01 · answer #2 · answered by Trinity 4 · 0⤊ 1⤋