Last workday

M

Mortir

How could i create a function that would aways show me last workday
before today? so for example:

1.today is wednesday 15 jun. So the function would show: tuesday 14
jun
2. today is monday 13 jun and the funtion would show: friday 10 jun

tnx for your help
 
C

Claus Busch

Hello,

Am Wed, 15 Jun 2011 03:57:05 -0700 (PDT) schrieb Mortir:
1.today is wednesday 15 jun. So the function would show: tuesday 14
jun
2. today is monday 13 jun and the funtion would show: friday 10 jun

your date in A1. Then try:
=A1-CHOOSE(WEEKDAY(A1),2,3,1,1,1,1,1)


Regards
Claus Busch
 
R

Rick Rothstein

How could i create a function that would aways show me last
workday before today? so for example:

1.today is wednesday 15 jun. So the function would show:
tuesday 14 jun
2. today is monday 13 jun and the funtion would show:
friday 10 jun

Try this formula...

=WORKDAY(A1,-1)

If you are using XL2003 or earlier, then you need to have the Analysis
ToolPak add-in selected (Tools/Add-Ins on the menu bar).

Rick Rothstein (MVP - Excel)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top