Posted to microsoft.public.excel.worksheet.functions

HK[_3_]

external usenet poster

Posts: 15

Date minus work days

In A1 i have: 29-May-2010
In A2: 20 (workdays)
In A3: 13-May-2010 (holiday)
In A4: 24-May-2010 (holiday)

I need to find the date of A1 minus number of workdays in A2, considering
the holidays in A3:A4.

Hans Knudsen

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
Date Calculation Formula- Calendar days minus Holidays	Amanda	Excel Worksheet Functions	1	September 1st 09 09:57 PM
get a runing total for"curent date"or(cell)minus prev 30 days( cel	dustin	Excel Worksheet Functions	2	August 1st 06 09:59 AM
Date minus date=No. of days?	Scoville	Excel Worksheet Functions	2	March 2nd 06 09:14 PM
date (minus) date = working days diff	jjj	Excel Discussion (Misc queries)	3	December 6th 05 03:16 PM
Excel running date formula minus weekend days	Eliane	Excel Worksheet Functions	2	March 30th 05 10:37 PM

All times are GMT +1. The time now is 08:32 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us