Thread: Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Ron Rosenfeld Ron Rosenfeld is offline
external usenet poster
  
Posts: 5,651
Default Coding to show first _weekday_ prior to a date, when date calculation happens to fall on weekend?
On Wed, 08 Dec 2004 07:43:31 -0500, StargateFan
wrote:

And the 3 week code is:
=IF(B3<"",SUM(B3-21),"")

=IF(B3<"",workday(B3-20,-1),"")



And the 1 week code is:
=IF(B3<"",SUM(B3-7),"")


=IF(B3<"",workday(B3-6,-1),"")

If the WORKDAY function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

On the Tools menu, click Add-Ins.
In the Add-Ins available list, select the Analysis ToolPak box, and then click
OK.
If necessary, follow the instructions in the setup program.


--ron
Reply With QuoteReply With Quote