Alternative to WORKDAY when Analysis ToolPak not loaded
 

I have a simple formula in a workbook that indicates the previous
workday from today's date:

=WORKDAY(TODAY(),-1)

So, for example, if today is Monday, the formula above gives last
Friday's date. Or, if today is Wednesdsay, it indicates yesterday's
date (Tuesday). (Holidays are not pertinent here.)

Unfortunately, a few people to whom I distribute this workbook do not
have Analysis ToolPak installed, so that particular cell (and all the
cells that refer to that cell) shows #NAME?

Is there an alternative formula to WORKDAY that I can use that will
indicate the previous workday from today? (Again, Holidays are not
pertinent as we will always be looking for a Monday-Friday date).

Many thanks.

Alternative to WORKDAY when Analysis ToolPak not loaded
 

=IF(AND(WEEKDAY(TODAY())=3,WEEKDAY(TODAY())<=7),T ODAY()-1,IF(WEEKDAY
(TODAY())=2,TODAY()-3,TODAY()-2))

HTH


On 23 Mar, 14:19, "Paul D. Simon" wrote:
I have a simple formula in a workbook that indicates the previous
workday from today's date:

=WORKDAY(TODAY(),-1)

So, for example, if today is Monday, the formula above gives last
Friday's date. *Or, if today is Wednesdsay, it indicates yesterday's
date (Tuesday). *(Holidays are not pertinent here.)

Unfortunately, a few people to whom I distribute this workbook do not
have Analysis ToolPak installed, so that particular cell (and all the
cells that refer to that cell) shows #NAME?

Is there an alternative formula to WORKDAY that I can use that will
indicate the previous workday from today? *(Again, Holidays are not
pertinent as we will always be looking for a Monday-Friday date).

Many thanks.

Alternative to WORKDAY when Analysis ToolPak not loaded
 

Paul,

=TODAY()-IF(MOD(TODAY(),7)=2,3,1)

should work.

HTH,
Bernie
MS Excel MVP


"Paul D. Simon" wrote in message
...
I have a simple formula in a workbook that indicates the previous
workday from today's date:

=WORKDAY(TODAY(),-1)

So, for example, if today is Monday, the formula above gives last
Friday's date. Or, if today is Wednesdsay, it indicates yesterday's
date (Tuesday). (Holidays are not pertinent here.)

Unfortunately, a few people to whom I distribute this workbook do not
have Analysis ToolPak installed, so that particular cell (and all the
cells that refer to that cell) shows #NAME?

Is there an alternative formula to WORKDAY that I can use that will
indicate the previous workday from today? (Again, Holidays are not
pertinent as we will always be looking for a Monday-Friday date).

Many thanks.

Alternative to WORKDAY when Analysis ToolPak not loaded
 

this is what I meant
just was not able to phrase it
;-)


On 23 Mar, 14:45, "Bernie Deitrick" <deitbe @ consumer dot org wrote:
Paul,

=TODAY()-IF(MOD(TODAY(),7)=2,3,1)

should work.

HTH,
Bernie
MS Excel MVP

"Paul D. Simon" wrote in ...



I have a simple formula in a workbook that indicates the previous
workday from today's date:

=WORKDAY(TODAY(),-1)

So, for example, if today is Monday, the formula above gives last
Friday's date. *Or, if today is Wednesdsay, it indicates yesterday's
date (Tuesday). *(Holidays are not pertinent here.)

Unfortunately, a few people to whom I distribute this workbook do not
have Analysis ToolPak installed, so that particular cell (and all the
cells that refer to that cell) shows #NAME?

Is there an alternative formula to WORKDAY that I can use that will
indicate the previous workday from today? *(Again, Holidays are not
pertinent as we will always be looking for a Monday-Friday date).

Many thanks.- Ukryj cytowany tekst -

- Poka¿ cytowany tekst -

Alternative to WORKDAY when Analysis ToolPak not loaded
 

If you assume that TODAY() is never Sunday.

Bernie Deitrick wrote:
Paul,

=TODAY()-IF(MOD(TODAY(),7)=2,3,1)

should work.

HTH,
Bernie
MS Excel MVP


"Paul D. Simon" wrote in message
...
I have a simple formula in a workbook that indicates the previous
workday from today's date:

=WORKDAY(TODAY(),-1)

So, for example, if today is Monday, the formula above gives last
Friday's date. Or, if today is Wednesdsay, it indicates yesterday's
date (Tuesday). (Holidays are not pertinent here.)

Unfortunately, a few people to whom I distribute this workbook do not
have Analysis ToolPak installed, so that particular cell (and all the
cells that refer to that cell) shows #NAME?

Is there an alternative formula to WORKDAY that I can use that will
indicate the previous workday from today? (Again, Holidays are not
pertinent as we will always be looking for a Monday-Friday date).

Many thanks.

Alternative to WORKDAY when Analysis ToolPak not loaded
 

Paul D. Simon wrote:
I have a simple formula in a workbook that indicates the previous
workday from today's date:

=WORKDAY(TODAY(),-1)

So, for example, if today is Monday, the formula above gives last
Friday's date. Or, if today is Wednesdsay, it indicates yesterday's
date (Tuesday). (Holidays are not pertinent here.)

Unfortunately, a few people to whom I distribute this workbook do not
have Analysis ToolPak installed, so that particular cell (and all the
cells that refer to that cell) shows #NAME?

Is there an alternative formula to WORKDAY that I can use that will
indicate the previous workday from today? (Again, Holidays are not
pertinent as we will always be looking for a Monday-Friday date).

Many thanks.


=TODAY()-CHOOSE(MOD(TODAY(),7)+1,1,2,3,1,1,1,1)

Alternative to WORKDAY when Analysis ToolPak not loaded
 

Try following formula,

=IF(WEEKDAY(TODAY())=2,TODAY()-3,IF(WEEKDAY(TODAY())=1,TODAY()-2,TODAY()-1))
--
HARSHAWARDHAN.S.SHASTRI

Pl do not forget to press "YES" button if post found useful.

++++++++++++++++++++++++++++++++++++++++++++++++++ ++++++++


"Paul D. Simon" wrote:

I have a simple formula in a workbook that indicates the previous
workday from today's date:

=WORKDAY(TODAY(),-1)

So, for example, if today is Monday, the formula above gives last
Friday's date. Or, if today is Wednesdsay, it indicates yesterday's
date (Tuesday). (Holidays are not pertinent here.)

Unfortunately, a few people to whom I distribute this workbook do not
have Analysis ToolPak installed, so that particular cell (and all the
cells that refer to that cell) shows #NAME?

Is there an alternative formula to WORKDAY that I can use that will
indicate the previous workday from today? (Again, Holidays are not
pertinent as we will always be looking for a Monday-Friday date).

Many thanks.

Alternative to WORKDAY when Analysis ToolPak not loaded
 

Jarek, Bernie and Glenn,

Thank you all for your very speedy and very helpful responses. All of
your formulas worked absolutely perfectly! (And yes, Glenn, TODAY()
would never be a Sunday.)

Thanks very, very much to you all!

Paul

Alternative to WORKDAY when Analysis ToolPak not loaded
 

Thank you Harshawardhan. Your formula works perfectly as well.
Thanks for your fast response - I appreciate it.

Alternative to WORKDAY when Analysis ToolPak not loaded