Posted to microsoft.public.excel.worksheet.functions

orquidea

external usenet poster

Posts: 132

Dates formula

Thanks Carlo

"Carlo" wrote:

Hi Orquidea

try this formula

=((A1-A2-WEEKDAY(A1)+WEEKDAY(A2)-7)/7*5)+WEEKDAY(A1)-WEEKDAY(A2)+5

where A1 is the later date.

hth

Carlo

"orquidea" wrote:

Hi

I want to deduct 2 dates. I also want to deduct weekend days if they are
within the period of time of the calculation. e.i

10/23/07 - 10/18/07 = 5 days minus 2 weekend days = 3 days

I want to get 3 days result.

Could someone help with this formula please.

Thanks
Orquidea

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
Dates formula	davey	Excel Worksheet Functions	6	July 21st 07 08:18 PM
How Do I Add Dates in a formula?	Rogue	Excel Worksheet Functions	3	January 9th 06 07:12 AM
Need a Formula for DATES	Debbie	Excel Worksheet Functions	2	November 8th 05 02:46 PM
formula for dates	pascot	Excel Discussion (Misc queries)	1	June 21st 05 08:33 AM
Dates in Formula	John G	Excel Discussion (Misc queries)	10	January 15th 05 03:48 PM

All times are GMT +1. The time now is 10:31 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us