Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Get Holidays in cell/s between star & End dates?
Dear Mike. H, I am trying to explain in details.
I have data for Excel woksheet for project as "Leave Application" 1) Start Date in "cell A1" (e.g. 12 Dec 2007) 2) End Date in "cell A2" (e.g. 31 Dec 2007) 3) Total holidays of year 2007 in "column B" (e.g. 26 Jan, 1 May, 2 Oct,-----,14 Dec, 25 Dec) I got the results as follows: Total leaves incluing holidays = 15 (Note: modified workdays as 6 days -got hepl by Greg willson) (12,13,15,17,18,19,20,21,22,24,26,27,28,29,31 Dec 2007) I have to fill one cell named as "Holidays on: ". So, the Holidays dates between start & End date should be automaticaly filled in the cell/s. How to formulate it??? If my question is clear to you, please give me solution for this. I will be thankful to you. Nilay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Write Holidays between two dates? | Excel Worksheet Functions | |||
Checking Dates against Bank Holidays | Excel Worksheet Functions | |||
How to exlude holidays from a range of dates | Excel Discussion (Misc queries) | |||
Dates with Holidays question | Excel Discussion (Misc queries) | |||
Skip holidays falling between two dates | Excel Worksheet Functions |