Posted to microsoft.public.excel.worksheet.functions

Mortir

external usenet poster

Posts: 34

Last workday

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Add no. of days to a workday to get new workday?	blswes	Excel Worksheet Functions	1	April 15th 10 07:39 PM
Workday	native earthling	Excel Worksheet Functions	3	April 6th 09 03:45 AM
WORKDAY	Daniel Q.	Excel Worksheet Functions	6	August 13th 08 03:20 PM
WORKDAY() and probably more	Epinn	New Users to Excel	19	September 24th 06 01:19 PM
Workday Help	mhart210	Excel Discussion (Misc queries)	3	July 10th 06 03:20 PM

All times are GMT +1. The time now is 06:18 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us