How do I create a formula in excel to show me the last business day before today?

Question

I need a formula to show me the last business day before today, I don't really care about holidays. Basically If today is Monday Feb 12th I want the formula to show me Friday Feb 9th. I tried the =Today()-1 but on monday it will show me sundays date which is not a business day.

Answer 1

Here's the formula:

=WORKDAY(TODAY(),-1)

Format result as a date.

Answer 2

i take advantage of Open workplace this is amazingly equivalent to Excel In Open workplace the two cells with the dates ought to be formatted as date cells. I even have entered 12/09/10 into cellular A1 and 18/10/10 into cellular A2 and placed the respond into cellular A3. (Cells A1 and A2 comprise dates in uk format) The cellular A3 ought to comprise a function to do the calculation it rather is often accomplished by utilizing clicking on the cellular to opt for it. opt for insert from the gadget bar and choosing function from the drop down menu. The function to apply is sum (The sum function commonly starts off with an = image)

Answer 3

On the Tools menu, click Add-Ins.

In the Add-Ins available list, select the Analysis ToolPak box, and then click OK.

Then use the

=WORKDAY() function

Make sure fields are formated as date fields

Answer 4

=IF(WEEKDAY(TODAY())=2, TEXT(TODAY()-3, "dd/mm/yyyy"), TEXT(TODAY()-1,"dd/mm/yyyy"))