software

Hi there.

I've been working on is a time sheet (and almost done with it). During
our work periods throught the year we accrue holidays (just like vacation
time).
What I'm wanting to do is compare the present work period dates (I have
the dates in ms date format in F51:AF52), to a list that I manually have
looked up of the holiday dates (this is in the ms date format in A4:A103 on
the data sheet). In cell C28 on the time sheet, I need the name of the
holiday and/or holidays that have accrued during the pay period (thats in the
cell next to dates in B4:B103 on the data sheet). Hope I haven't lost you yet.
What I have:

Data Sheet

38718New Years Day
38733Martin Luther King Jr. Day
38768Presidents Day
38866Memorial Day
38902Fourth of July
38964Labor Day
39044Thanksgiving Day
39045Day after Thanksgiving Day
39075Christmas Eve
39076Christmas DayWhat I've been using:

=IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
Sheet'!A4:B103,2))
This only lists the last match that it finds, and not all the matches,
which
is what I actually need.What I need (in C28) if the pay period was from 12/26/2005 thru 01/21,2006:

Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.

I think this is possible, I'm not savvy enough in Excel to figure this out
on my own. This is way over my head. Any help is appreciated. Thanks....BenBen,
You will (probably) need VBA code to do this as we have to find
all holiday days between two dates. Couple of questions:

What's in C51 in your example?

How do we know which pay period we are in: I assume rows 51/52 are start/end
dates of a given period?

If you prefer, post the workbook and I'll have a look
)

quot;ben simpsonquot; wrote:

gt; Hi there.
gt;
gt; I've been working on is a time sheet (and almost done with it). During
gt; our work periods throught the year we accrue holidays (just like vacation
gt; time).
gt; What I'm wanting to do is compare the present work period dates (I have
gt; the dates in ms date format in F51:AF52), to a list that I manually have
gt; looked up of the holiday dates (this is in the ms date format in A4:A103 on
gt; the data sheet). In cell C28 on the time sheet, I need the name of the
gt; holiday and/or holidays that have accrued during the pay period (thats in the
gt; cell next to dates in B4:B103 on the data sheet). Hope I haven't lost you yet.
gt; What I have:
gt;
gt; Data Sheet
gt;
gt; 38718New Years Day
gt; 38733Martin Luther King Jr. Day
gt; 38768Presidents Day
gt; 38866Memorial Day
gt; 38902Fourth of July
gt; 38964Labor Day
gt; 39044Thanksgiving Day
gt; 39045Day after Thanksgiving Day
gt; 39075Christmas Eve
gt; 39076Christmas Day
gt;
gt;
gt; What I've been using:
gt;
gt; =IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
gt; Sheet'!A4:B103,2))
gt; This only lists the last match that it finds, and not all the matches,
gt; which
gt; is what I actually need.
gt;
gt;
gt; What I need (in C28) if the pay period was from 12/26/2005 thru 01/21,2006:
gt;
gt; Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.
gt;
gt; I think this is possible, I'm not savvy enough in Excel to figure this out
gt; on my own. This is way over my head. Any help is appreciated. Thanks....Ben
gt;

Hi topper.
C51 is a =TODAY() and you're right... rows 51 and 52 are the dates of the
pay cycle. Unfortuneately I can't post because the powers that be will not
allow it. I know that the IT dept. is very strict on the running of any VBA
code (way too over protective), so I was looking for a way to do it through
some sort of formula. But, I'm very willing to listen, and if necessary try
to get that OK'd. Thanks again...Ben

quot;Toppersquot; wrote:

gt; Ben,
gt; You will (probably) need VBA code to do this as we have to find
gt; all holiday days between two dates. Couple of questions:
gt;
gt; What's in C51 in your example?
gt;
gt; How do we know which pay period we are in: I assume rows 51/52 are start/end
gt; dates of a given period?
gt;
gt; If you prefer, post the workbook and I'll have a look
gt; )
gt;
gt; quot;ben simpsonquot; wrote:
gt;
gt; gt; Hi there.
gt; gt;
gt; gt; I've been working on is a time sheet (and almost done with it). During
gt; gt; our work periods throught the year we accrue holidays (just like vacation
gt; gt; time).
gt; gt; What I'm wanting to do is compare the present work period dates (I have
gt; gt; the dates in ms date format in F51:AF52), to a list that I manually have
gt; gt; looked up of the holiday dates (this is in the ms date format in A4:A103 on
gt; gt; the data sheet). In cell C28 on the time sheet, I need the name of the
gt; gt; holiday and/or holidays that have accrued during the pay period (thats in the
gt; gt; cell next to dates in B4:B103 on the data sheet). Hope I haven't lost you yet.
gt; gt; What I have:
gt; gt;
gt; gt; Data Sheet
gt; gt;
gt; gt; 38718New Years Day
gt; gt; 38733Martin Luther King Jr. Day
gt; gt; 38768Presidents Day
gt; gt; 38866Memorial Day
gt; gt; 38902Fourth of July
gt; gt; 38964Labor Day
gt; gt; 39044Thanksgiving Day
gt; gt; 39045Day after Thanksgiving Day
gt; gt; 39075Christmas Eve
gt; gt; 39076Christmas Day
gt; gt;
gt; gt;
gt; gt; What I've been using:
gt; gt;
gt; gt; =IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
gt; gt; Sheet'!A4:B103,2))
gt; gt; This only lists the last match that it finds, and not all the matches,
gt; gt; which
gt; gt; is what I actually need.
gt; gt;
gt; gt;
gt; gt; What I need (in C28) if the pay period was from 12/26/2005 thru 01/21,2006:
gt; gt;
gt; gt; Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.
gt; gt;
gt; gt; I think this is possible, I'm not savvy enough in Excel to figure this out
gt; gt; on my own. This is way over my head. Any help is appreciated. Thanks....Ben
gt; gt;

I told you this would be complicated!

I'm assuming that:

row 51 = start of period
row 52 = end of period

Try this:

Entered as an array using the key combo of CTRL,SHIF,ENTER:

=INDEX(B$4:B$103,SMALL(IF((A$4:A$103gt;=INDEX(F$51:A F$51,MATCH(C$51,F$51:AF$51,1)))*(A$4:A$103lt;=INDEX( F$52:AF$52,MATCH(C$51,F$51:AF$51,1))),ROW(A$4:A$10 3)-ROW(A$4) 1),ROWS($1:1)))

Copy down until you get #NUM! errors. If you want an error trap the formula
will be twice as long!!!!!!!!

Biff

quot;ben simpsonquot; gt; wrote in message
...
gt; Hi there.
gt;
gt; I've been working on is a time sheet (and almost done with it). During
gt; our work periods throught the year we accrue holidays (just like vacation
gt; time).
gt; What I'm wanting to do is compare the present work period dates (I have
gt; the dates in ms date format in F51:AF52), to a list that I manually have
gt; looked up of the holiday dates (this is in the ms date format in A4:A103
gt; on
gt; the data sheet). In cell C28 on the time sheet, I need the name of the
gt; holiday and/or holidays that have accrued during the pay period (thats in
gt; the
gt; cell next to dates in B4:B103 on the data sheet). Hope I haven't lost you
gt; yet.
gt; What I have:
gt;
gt; Data Sheet
gt;
gt; 38718 New Years Day
gt; 38733 Martin Luther King Jr. Day
gt; 38768 Presidents Day
gt; 38866 Memorial Day
gt; 38902 Fourth of July
gt; 38964 Labor Day
gt; 39044 Thanksgiving Day
gt; 39045 Day after Thanksgiving Day
gt; 39075 Christmas Eve
gt; 39076 Christmas Day
gt;
gt;
gt; What I've been using:
gt;
gt; =IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
gt; Sheet'!A4:B103,2))
gt; This only lists the last match that it finds, and not all the
gt; matches,
gt; which
gt; is what I actually need.
gt;
gt;
gt; What I need (in C28) if the pay period was from 12/26/2005 thru
gt; 01/21,2006:
gt;
gt; Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.
gt;
gt; I think this is possible, I'm not savvy enough in Excel to figure this
gt; out
gt; on my own. This is way over my head. Any help is appreciated.
gt; Thanks....Ben
gt;
Ben,
this is probably the minimum VBA we can get away with. It is a
function which returns your holiday list between two dates. It assumes the
dates in your holiday data (a4:A103) is in ascending date order and I have
called this data quot;HOLIDAYSquot; - a named range.

in C28 put:

=AccruedHolidays(lt;startdategt;,lt;enddategt;)

e.g.

=AccruedHolidays(quot;26/12/2005quot;, quot;21/01/2006quot;)

I hope you can put this in your w/book.

HTH

=============================================

Function AccruedHolidays(ByVal ppStart As Date, ByVal ppEnd As Date)
holStr = quot;quot;
For Each cell In Range(quot;Holidaysquot;)
If CLng(cell.Value) gt; CLng(ppEnd) Then
Exit For
Else
If CLng(cell.Value) gt;= CLng(ppStart) Then
holStr = holStr amp; cell.Offset(0, 1) amp; quot;,quot;
End If
End If
Next cell
AccruedHolidays = Left(holStr, Len(holStr) - 1)
End Function

quot;ben simpsonquot; wrote:

gt; Hi topper.
gt; C51 is a =TODAY() and you're right... rows 51 and 52 are the dates of the
gt; pay cycle. Unfortuneately I can't post because the powers that be will not
gt; allow it. I know that the IT dept. is very strict on the running of any VBA
gt; code (way too over protective), so I was looking for a way to do it through
gt; some sort of formula. But, I'm very willing to listen, and if necessary try
gt; to get that OK'd. Thanks again...Ben
gt;
gt; quot;Toppersquot; wrote:
gt;
gt; gt; Ben,
gt; gt; You will (probably) need VBA code to do this as we have to find
gt; gt; all holiday days between two dates. Couple of questions:
gt; gt;
gt; gt; What's in C51 in your example?
gt; gt;
gt; gt; How do we know which pay period we are in: I assume rows 51/52 are start/end
gt; gt; dates of a given period?
gt; gt;
gt; gt; If you prefer, post the workbook and I'll have a look
gt; gt; )
gt; gt;
gt; gt; quot;ben simpsonquot; wrote:
gt; gt;
gt; gt; gt; Hi there.
gt; gt; gt;
gt; gt; gt; I've been working on is a time sheet (and almost done with it). During
gt; gt; gt; our work periods throught the year we accrue holidays (just like vacation
gt; gt; gt; time).
gt; gt; gt; What I'm wanting to do is compare the present work period dates (I have
gt; gt; gt; the dates in ms date format in F51:AF52), to a list that I manually have
gt; gt; gt; looked up of the holiday dates (this is in the ms date format in A4:A103 on
gt; gt; gt; the data sheet). In cell C28 on the time sheet, I need the name of the
gt; gt; gt; holiday and/or holidays that have accrued during the pay period (thats in the
gt; gt; gt; cell next to dates in B4:B103 on the data sheet). Hope I haven't lost you yet.
gt; gt; gt; What I have:
gt; gt; gt;
gt; gt; gt; Data Sheet
gt; gt; gt;
gt; gt; gt; 38718New Years Day
gt; gt; gt; 38733Martin Luther King Jr. Day
gt; gt; gt; 38768Presidents Day
gt; gt; gt; 38866Memorial Day
gt; gt; gt; 38902Fourth of July
gt; gt; gt; 38964Labor Day
gt; gt; gt; 39044Thanksgiving Day
gt; gt; gt; 39045Day after Thanksgiving Day
gt; gt; gt; 39075Christmas Eve
gt; gt; gt; 39076Christmas Day
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; What I've been using:
gt; gt; gt;
gt; gt; gt; =IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
gt; gt; gt; Sheet'!A4:B103,2))
gt; gt; gt; This only lists the last match that it finds, and not all the matches,
gt; gt; gt; which
gt; gt; gt; is what I actually need.
gt; gt; gt;
gt; gt; gt;
gt; gt; gt; What I need (in C28) if the pay period was from 12/26/2005 thru 01/21,2006:
gt; gt; gt;
gt; gt; gt; Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.
gt; gt; gt;
gt; gt; gt; I think this is possible, I'm not savvy enough in Excel to figure this out
gt; gt; gt; on my own. This is way over my head. Any help is appreciated. Thanks....Ben
gt; gt; gt;

Yikes...you weren't kidding. I copied the formula down, and pasted it in. I
had to change the cell references to the correct sheet (sorry if I wasn't
clear). Now it giving me a #REF error, and I don't know why. Here's what i
have now:
As an array.

=INDEX('Data Sheet'!B4:B103,SMALL(IF(('Data
Sheet'!A4:A103gt;=INDEX(F$51:AF$51,MATCH(C$51,F$51:A F$51,1)))*('Data
Sheet'!A4:A103lt;=INDEX(F$51:AF$52,MATCH(C$51,F$51:A F$51,1))),ROW('Data
Sheet'!A4:A103)-ROW('Data Sheet'!A4) 1),ROWS($1:1)))

I have no clue as to what you meant by error trap the formula. Can you
clarify that for me?.....Thanks....Benquot;Biffquot; wrote:

gt; I told you this would be complicated!
gt;
gt; I'm assuming that:
gt;
gt; row 51 = start of period
gt; row 52 = end of period
gt;
gt; Try this:
gt;
gt; Entered as an array using the key combo of CTRL,SHIF,ENTER:
gt;
gt; =INDEX(B$4:B$103,SMALL(IF((A$4:A$103gt;=INDEX(F$51:A F$51,MATCH(C$51,F$51:AF$51,1)))*(A$4:A$103lt;=INDEX( F$52:AF$52,MATCH(C$51,F$51:AF$51,1))),ROW(A$4:A$10 3)-ROW(A$4) 1),ROWS($1:1)))
gt;
gt; Copy down until you get #NUM! errors. If you want an error trap the formula
gt; will be twice as long!!!!!!!!
gt;
gt; Biff
gt;
gt; quot;ben simpsonquot; gt; wrote in message
gt; ...
gt; gt; Hi there.
gt; gt;
gt; gt; I've been working on is a time sheet (and almost done with it). During
gt; gt; our work periods throught the year we accrue holidays (just like vacation
gt; gt; time).
gt; gt; What I'm wanting to do is compare the present work period dates (I have
gt; gt; the dates in ms date format in F51:AF52), to a list that I manually have
gt; gt; looked up of the holiday dates (this is in the ms date format in A4:A103
gt; gt; on
gt; gt; the data sheet). In cell C28 on the time sheet, I need the name of the
gt; gt; holiday and/or holidays that have accrued during the pay period (thats in
gt; gt; the
gt; gt; cell next to dates in B4:B103 on the data sheet). Hope I haven't lost you
gt; gt; yet.
gt; gt; What I have:
gt; gt;
gt; gt; Data Sheet
gt; gt;
gt; gt; 38718 New Years Day
gt; gt; 38733 Martin Luther King Jr. Day
gt; gt; 38768 Presidents Day
gt; gt; 38866 Memorial Day
gt; gt; 38902 Fourth of July
gt; gt; 38964 Labor Day
gt; gt; 39044 Thanksgiving Day
gt; gt; 39045 Day after Thanksgiving Day
gt; gt; 39075 Christmas Eve
gt; gt; 39076 Christmas Day
gt; gt;
gt; gt;
gt; gt; What I've been using:
gt; gt;
gt; gt; =IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
gt; gt; Sheet'!A4:B103,2))
gt; gt; This only lists the last match that it finds, and not all the
gt; gt; matches,
gt; gt; which
gt; gt; is what I actually need.
gt; gt;
gt; gt;
gt; gt; What I need (in C28) if the pay period was from 12/26/2005 thru
gt; gt; 01/21,2006:
gt; gt;
gt; gt; Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.
gt; gt;
gt; gt; I think this is possible, I'm not savvy enough in Excel to figure this
gt; gt; out
gt; gt; on my own. This is way over my head. Any help is appreciated.
gt; gt; Thanks....Ben
gt; gt;
gt;
gt;
gt;

This portion:

lt;=INDEX(F$51:AF$52,MATCH(C$51,F$51:AF$51,1)))

Should be:

lt;=INDEX(F$52:AF$52,MATCH(C$51,F$51:AF$51,1)))

Also, since there may be more than one match, when you copy the formula down
you don't want these ranges to increment, do you?

'Data Sheet'!B4:B103
'Data Sheet'!A4:A103

So, make the row references absolute:

'Data Sheet'!B$4:B$103
'Data Sheet'!A$4:A$103

gt; I have no clue as to what you meant by error trap the formula. Can you
gt; clarify that for me?

When you got the #REF! error, an error trap is a portion of the formula that
quot;anticipatesquot; when errors will be generated and prevents them from being
displayed. Let's get the basic formula working first then we'll deal with
errors later!

Biff

quot;ben simpsonquot; gt; wrote in message
...
gt; Yikes...you weren't kidding. I copied the formula down, and pasted it in.
gt; I
gt; had to change the cell references to the correct sheet (sorry if I wasn't
gt; clear). Now it giving me a #REF error, and I don't know why. Here's what
gt; i
gt; have now:
gt; As an array.
gt;
gt; =INDEX('Data Sheet'!B4:B103,SMALL(IF(('Data
gt; Sheet'!A4:A103gt;=INDEX(F$51:AF$51,MATCH(C$51,F$51:A F$51,1)))*('Data
gt; Sheet'!A4:A103lt;=INDEX(F$51:AF$52,MATCH(C$51,F$51:A F$51,1))),ROW('Data
gt; Sheet'!A4:A103)-ROW('Data Sheet'!A4) 1),ROWS($1:1)))
gt;
gt; I have no clue as to what you meant by error trap the formula. Can you
gt; clarify that for me?.....Thanks....Ben
gt;
gt;
gt;
gt;
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; I told you this would be complicated!
gt;gt;
gt;gt; I'm assuming that:
gt;gt;
gt;gt; row 51 = start of period
gt;gt; row 52 = end of period
gt;gt;
gt;gt; Try this:
gt;gt;
gt;gt; Entered as an array using the key combo of CTRL,SHIF,ENTER:
gt;gt;
gt;gt; =INDEX(B$4:B$103,SMALL(IF((A$4:A$103gt;=INDEX(F$51:A F$51,MATCH(C$51,F$51:AF$51,1)))*(A$4:A$103lt;=INDEX( F$52:AF$52,MATCH(C$51,F$51:AF$51,1))),ROW(A$4:A$10 3)-ROW(A$4) 1),ROWS($1:1)))
gt;gt;
gt;gt; Copy down until you get #NUM! errors. If you want an error trap the
gt;gt; formula
gt;gt; will be twice as long!!!!!!!!
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;ben simpsonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Hi there.
gt;gt; gt;
gt;gt; gt; I've been working on is a time sheet (and almost done with it).
gt;gt; gt; During
gt;gt; gt; our work periods throught the year we accrue holidays (just like
gt;gt; gt; vacation
gt;gt; gt; time).
gt;gt; gt; What I'm wanting to do is compare the present work period dates (I
gt;gt; gt; have
gt;gt; gt; the dates in ms date format in F51:AF52), to a list that I manually
gt;gt; gt; have
gt;gt; gt; looked up of the holiday dates (this is in the ms date format in
gt;gt; gt; A4:A103
gt;gt; gt; on
gt;gt; gt; the data sheet). In cell C28 on the time sheet, I need the name of the
gt;gt; gt; holiday and/or holidays that have accrued during the pay period (thats
gt;gt; gt; in
gt;gt; gt; the
gt;gt; gt; cell next to dates in B4:B103 on the data sheet). Hope I haven't lost
gt;gt; gt; you
gt;gt; gt; yet.
gt;gt; gt; What I have:
gt;gt; gt;
gt;gt; gt; Data Sheet
gt;gt; gt;
gt;gt; gt; 38718 New Years Day
gt;gt; gt; 38733 Martin Luther King Jr. Day
gt;gt; gt; 38768 Presidents Day
gt;gt; gt; 38866 Memorial Day
gt;gt; gt; 38902 Fourth of July
gt;gt; gt; 38964 Labor Day
gt;gt; gt; 39044 Thanksgiving Day
gt;gt; gt; 39045 Day after Thanksgiving Day
gt;gt; gt; 39075 Christmas Eve
gt;gt; gt; 39076 Christmas Day
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; What I've been using:
gt;gt; gt;
gt;gt; gt; =IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
gt;gt; gt; Sheet'!A4:B103,2))
gt;gt; gt; This only lists the last match that it finds, and not all the
gt;gt; gt; matches,
gt;gt; gt; which
gt;gt; gt; is what I actually need.
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; What I need (in C28) if the pay period was from 12/26/2005 thru
gt;gt; gt; 01/21,2006:
gt;gt; gt;
gt;gt; gt; Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.
gt;gt; gt;
gt;gt; gt; I think this is possible, I'm not savvy enough in Excel to figure this
gt;gt; gt; out
gt;gt; gt; on my own. This is way over my head. Any help is appreciated.
gt;gt; gt; Thanks....Ben
gt;gt; gt;
gt;gt;
gt;gt;
gt;gt;
I got the areas fixed that you pointed out. Now I get a #NUM error. i need
guidance from here (obviously...hehehe). This is what it looks like.
In an array of course.

=INDEX('Data Sheet'!B$4:B$103,SMALL(IF(('Data
Sheet'!A$4:A$103gt;=INDEX(F$51:AF$51,MATCH(C$51,F$51 :AF$51,1)))*('Data
Sheet'!A$4:A$103lt;=INDEX(F$52:AF$52,MATCH(C$51,F$51 :AF$51,1))),ROW('Data
Sheet'!A$4:A$103)-ROW('Data Sheet'!A$4) 1),ROWS($1:1)))

Where does it go from here?.....Thanks....Ben

quot;Biffquot; wrote:

gt; This portion:
gt;
gt; lt;=INDEX(F$51:AF$52,MATCH(C$51,F$51:AF$51,1)))
gt;
gt; Should be:
gt;
gt; lt;=INDEX(F$52:AF$52,MATCH(C$51,F$51:AF$51,1)))
gt;
gt; Also, since there may be more than one match, when you copy the formula down
gt; you don't want these ranges to increment, do you?
gt;
gt; 'Data Sheet'!B4:B103
gt; 'Data Sheet'!A4:A103
gt;
gt; So, make the row references absolute:
gt;
gt; 'Data Sheet'!B$4:B$103
gt; 'Data Sheet'!A$4:A$103
gt;
gt; gt; I have no clue as to what you meant by error trap the formula. Can you
gt; gt; clarify that for me?
gt;
gt; When you got the #REF! error, an error trap is a portion of the formula that
gt; quot;anticipatesquot; when errors will be generated and prevents them from being
gt; displayed. Let's get the basic formula working first then we'll deal with
gt; errors later!
gt;
gt; Biff
gt;
gt; quot;ben simpsonquot; gt; wrote in message
gt; ...
gt; gt; Yikes...you weren't kidding. I copied the formula down, and pasted it in.
gt; gt; I
gt; gt; had to change the cell references to the correct sheet (sorry if I wasn't
gt; gt; clear). Now it giving me a #REF error, and I don't know why. Here's what
gt; gt; i
gt; gt; have now:
gt; gt; As an array.
gt; gt;
gt; gt; =INDEX('Data Sheet'!B4:B103,SMALL(IF(('Data
gt; gt; Sheet'!A4:A103gt;=INDEX(F$51:AF$51,MATCH(C$51,F$51:A F$51,1)))*('Data
gt; gt; Sheet'!A4:A103lt;=INDEX(F$51:AF$52,MATCH(C$51,F$51:A F$51,1))),ROW('Data
gt; gt; Sheet'!A4:A103)-ROW('Data Sheet'!A4) 1),ROWS($1:1)))
gt; gt;
gt; gt; I have no clue as to what you meant by error trap the formula. Can you
gt; gt; clarify that for me?.....Thanks....Ben
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt;
gt; gt; quot;Biffquot; wrote:
gt; gt;
gt; gt;gt; I told you this would be complicated!
gt; gt;gt;
gt; gt;gt; I'm assuming that:
gt; gt;gt;
gt; gt;gt; row 51 = start of period
gt; gt;gt; row 52 = end of period
gt; gt;gt;
gt; gt;gt; Try this:
gt; gt;gt;
gt; gt;gt; Entered as an array using the key combo of CTRL,SHIF,ENTER:
gt; gt;gt;
gt; gt;gt; =INDEX(B$4:B$103,SMALL(IF((A$4:A$103gt;=INDEX(F$51:A F$51,MATCH(C$51,F$51:AF$51,1)))*(A$4:A$103lt;=INDEX( F$52:AF$52,MATCH(C$51,F$51:AF$51,1))),ROW(A$4:A$10 3)-ROW(A$4) 1),ROWS($1:1)))
gt; gt;gt;
gt; gt;gt; Copy down until you get #NUM! errors. If you want an error trap the
gt; gt;gt; formula
gt; gt;gt; will be twice as long!!!!!!!!
gt; gt;gt;
gt; gt;gt; Biff
gt; gt;gt;
gt; gt;gt; quot;ben simpsonquot; gt; wrote in message
gt; gt;gt; ...
gt; gt;gt; gt; Hi there.
gt; gt;gt; gt;
gt; gt;gt; gt; I've been working on is a time sheet (and almost done with it).
gt; gt;gt; gt; During
gt; gt;gt; gt; our work periods throught the year we accrue holidays (just like
gt; gt;gt; gt; vacation
gt; gt;gt; gt; time).
gt; gt;gt; gt; What I'm wanting to do is compare the present work period dates (I
gt; gt;gt; gt; have
gt; gt;gt; gt; the dates in ms date format in F51:AF52), to a list that I manually
gt; gt;gt; gt; have
gt; gt;gt; gt; looked up of the holiday dates (this is in the ms date format in
gt; gt;gt; gt; A4:A103
gt; gt;gt; gt; on
gt; gt;gt; gt; the data sheet). In cell C28 on the time sheet, I need the name of the
gt; gt;gt; gt; holiday and/or holidays that have accrued during the pay period (thats
gt; gt;gt; gt; in
gt; gt;gt; gt; the
gt; gt;gt; gt; cell next to dates in B4:B103 on the data sheet). Hope I haven't lost
gt; gt;gt; gt; you
gt; gt;gt; gt; yet.
gt; gt;gt; gt; What I have:
gt; gt;gt; gt;
gt; gt;gt; gt; Data Sheet
gt; gt;gt; gt;
gt; gt;gt; gt; 38718 New Years Day
gt; gt;gt; gt; 38733 Martin Luther King Jr. Day
gt; gt;gt; gt; 38768 Presidents Day
gt; gt;gt; gt; 38866 Memorial Day
gt; gt;gt; gt; 38902 Fourth of July
gt; gt;gt; gt; 38964 Labor Day
gt; gt;gt; gt; 39044 Thanksgiving Day
gt; gt;gt; gt; 39045 Day after Thanksgiving Day
gt; gt;gt; gt; 39075 Christmas Eve
gt; gt;gt; gt; 39076 Christmas Day
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; What I've been using:
gt; gt;gt; gt;
gt; gt;gt; gt; =IF(ISNA(MATCH(F51:AF52,'Data Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
gt; gt;gt; gt; Sheet'!A4:B103,2))
gt; gt;gt; gt; This only lists the last match that it finds, and not all the
gt; gt;gt; gt; matches,
gt; gt;gt; gt; which
gt; gt;gt; gt; is what I actually need.
gt; gt;gt; gt;
gt; gt;gt; gt;
gt; gt;gt; gt; What I need (in C28) if the pay period was from 12/26/2005 thru
gt; gt;gt; gt; 01/21,2006:
gt; gt;gt; gt;
gt; gt;gt; gt; Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.
gt; gt;gt; gt;
gt; gt;gt; gt; I think this is possible, I'm not savvy enough in Excel to figure this
gt; gt;gt; gt; out
gt; gt;gt; gt; on my own. This is way over my head. Any help is appreciated.
gt; gt;gt; gt; Thanks....Ben
gt; gt;gt; gt;
gt; gt;gt;
gt; gt;gt;
gt; gt;gt;
gt;
gt;
gt;

#NUM! would mean there are no matches.

Send me an email..........if you can't send the file, just make a list of
these entries:

I need to know *EXACTLY* what you have in A4:A103, B4:B103, F51:AF51,
F52:AF52, C51. Don't just tell me that you have dates! I need to know WHAT
DATES!!!!!!!!!!

My address is: xlcanhelpatcomcastperiodnet

Remove quot;canquot; and change the obvious.

Biff

quot;ben simpsonquot; gt; wrote in message
...
gt;I got the areas fixed that you pointed out. Now I get a #NUM error. i
gt;need
gt; guidance from here (obviously...hehehe). This is what it looks like.
gt; In an array of course.
gt;
gt; =INDEX('Data Sheet'!B$4:B$103,SMALL(IF(('Data
gt; Sheet'!A$4:A$103gt;=INDEX(F$51:AF$51,MATCH(C$51,F$51 :AF$51,1)))*('Data
gt; Sheet'!A$4:A$103lt;=INDEX(F$52:AF$52,MATCH(C$51,F$51 :AF$51,1))),ROW('Data
gt; Sheet'!A$4:A$103)-ROW('Data Sheet'!A$4) 1),ROWS($1:1)))
gt;
gt; Where does it go from here?.....Thanks....Ben
gt;
gt; quot;Biffquot; wrote:
gt;
gt;gt; This portion:
gt;gt;
gt;gt; lt;=INDEX(F$51:AF$52,MATCH(C$51,F$51:AF$51,1)))
gt;gt;
gt;gt; Should be:
gt;gt;
gt;gt; lt;=INDEX(F$52:AF$52,MATCH(C$51,F$51:AF$51,1)))
gt;gt;
gt;gt; Also, since there may be more than one match, when you copy the formula
gt;gt; down
gt;gt; you don't want these ranges to increment, do you?
gt;gt;
gt;gt; 'Data Sheet'!B4:B103
gt;gt; 'Data Sheet'!A4:A103
gt;gt;
gt;gt; So, make the row references absolute:
gt;gt;
gt;gt; 'Data Sheet'!B$4:B$103
gt;gt; 'Data Sheet'!A$4:A$103
gt;gt;
gt;gt; gt; I have no clue as to what you meant by error trap the formula. Can you
gt;gt; gt; clarify that for me?
gt;gt;
gt;gt; When you got the #REF! error, an error trap is a portion of the formula
gt;gt; that
gt;gt; quot;anticipatesquot; when errors will be generated and prevents them from being
gt;gt; displayed. Let's get the basic formula working first then we'll deal with
gt;gt; errors later!
gt;gt;
gt;gt; Biff
gt;gt;
gt;gt; quot;ben simpsonquot; gt; wrote in message
gt;gt; ...
gt;gt; gt; Yikes...you weren't kidding. I copied the formula down, and pasted it
gt;gt; gt; in.
gt;gt; gt; I
gt;gt; gt; had to change the cell references to the correct sheet (sorry if I
gt;gt; gt; wasn't
gt;gt; gt; clear). Now it giving me a #REF error, and I don't know why. Here's
gt;gt; gt; what
gt;gt; gt; i
gt;gt; gt; have now:
gt;gt; gt; As an array.
gt;gt; gt;
gt;gt; gt; =INDEX('Data Sheet'!B4:B103,SMALL(IF(('Data
gt;gt; gt; Sheet'!A4:A103gt;=INDEX(F$51:AF$51,MATCH(C$51,F$51:A F$51,1)))*('Data
gt;gt; gt; Sheet'!A4:A103lt;=INDEX(F$51:AF$52,MATCH(C$51,F$51:A F$51,1))),ROW('Data
gt;gt; gt; Sheet'!A4:A103)-ROW('Data Sheet'!A4) 1),ROWS($1:1)))
gt;gt; gt;
gt;gt; gt; I have no clue as to what you meant by error trap the formula. Can you
gt;gt; gt; clarify that for me?.....Thanks....Ben
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt;
gt;gt; gt; quot;Biffquot; wrote:
gt;gt; gt;
gt;gt; gt;gt; I told you this would be complicated!
gt;gt; gt;gt;
gt;gt; gt;gt; I'm assuming that:
gt;gt; gt;gt;
gt;gt; gt;gt; row 51 = start of period
gt;gt; gt;gt; row 52 = end of period
gt;gt; gt;gt;
gt;gt; gt;gt; Try this:
gt;gt; gt;gt;
gt;gt; gt;gt; Entered as an array using the key combo of CTRL,SHIF,ENTER:
gt;gt; gt;gt;
gt;gt; gt;gt; =INDEX(B$4:B$103,SMALL(IF((A$4:A$103gt;=INDEX(F$51:A F$51,MATCH(C$51,F$51:AF$51,1)))*(A$4:A$103lt;=INDEX( F$52:AF$52,MATCH(C$51,F$51:AF$51,1))),ROW(A$4:A$10 3)-ROW(A$4) 1),ROWS($1:1)))
gt;gt; gt;gt;
gt;gt; gt;gt; Copy down until you get #NUM! errors. If you want an error trap the
gt;gt; gt;gt; formula
gt;gt; gt;gt; will be twice as long!!!!!!!!
gt;gt; gt;gt;
gt;gt; gt;gt; Biff
gt;gt; gt;gt;
gt;gt; gt;gt; quot;ben simpsonquot; gt; wrote in message
gt;gt; gt;gt; ...
gt;gt; gt;gt; gt; Hi there.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I've been working on is a time sheet (and almost done with it).
gt;gt; gt;gt; gt; During
gt;gt; gt;gt; gt; our work periods throught the year we accrue holidays (just like
gt;gt; gt;gt; gt; vacation
gt;gt; gt;gt; gt; time).
gt;gt; gt;gt; gt; What I'm wanting to do is compare the present work period dates (I
gt;gt; gt;gt; gt; have
gt;gt; gt;gt; gt; the dates in ms date format in F51:AF52), to a list that I manually
gt;gt; gt;gt; gt; have
gt;gt; gt;gt; gt; looked up of the holiday dates (this is in the ms date format in
gt;gt; gt;gt; gt; A4:A103
gt;gt; gt;gt; gt; on
gt;gt; gt;gt; gt; the data sheet). In cell C28 on the time sheet, I need the name of
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; holiday and/or holidays that have accrued during the pay period
gt;gt; gt;gt; gt; (thats
gt;gt; gt;gt; gt; in
gt;gt; gt;gt; gt; the
gt;gt; gt;gt; gt; cell next to dates in B4:B103 on the data sheet). Hope I haven't
gt;gt; gt;gt; gt; lost
gt;gt; gt;gt; gt; you
gt;gt; gt;gt; gt; yet.
gt;gt; gt;gt; gt; What I have:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Data Sheet
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; 38718 New Years Day
gt;gt; gt;gt; gt; 38733 Martin Luther King Jr. Day
gt;gt; gt;gt; gt; 38768 Presidents Day
gt;gt; gt;gt; gt; 38866 Memorial Day
gt;gt; gt;gt; gt; 38902 Fourth of July
gt;gt; gt;gt; gt; 38964 Labor Day
gt;gt; gt;gt; gt; 39044 Thanksgiving Day
gt;gt; gt;gt; gt; 39045 Day after Thanksgiving Day
gt;gt; gt;gt; gt; 39075 Christmas Eve
gt;gt; gt;gt; gt; 39076 Christmas Day
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; What I've been using:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; =IF(ISNA(MATCH(F51:AF52,'Data
gt;gt; gt;gt; gt; Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
gt;gt; gt;gt; gt; Sheet'!A4:B103,2))
gt;gt; gt;gt; gt; This only lists the last match that it finds, and not all the
gt;gt; gt;gt; gt; matches,
gt;gt; gt;gt; gt; which
gt;gt; gt;gt; gt; is what I actually need.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; What I need (in C28) if the pay period was from 12/26/2005 thru
gt;gt; gt;gt; gt; 01/21,2006:
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.
gt;gt; gt;gt; gt;
gt;gt; gt;gt; gt; I think this is possible, I'm not savvy enough in Excel to figure
gt;gt; gt;gt; gt; this
gt;gt; gt;gt; gt; out
gt;gt; gt;gt; gt; on my own. This is way over my head. Any help is appreciated.
gt;gt; gt;gt; gt; Thanks....Ben
gt;gt; gt;gt; gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt; gt;gt;
gt;gt;
gt;gt;
gt;gt;
If anybody is still following this thread........

The OP contacted me via email and provided a complete description of his
file layout and data.

The problem was in our (the respondents) interpretation of his post. The one
range of dates posted as being in F51:AF52 was actually a single row, row
51, but the two rows were merged! F51 was the start of the pay period and
AF51 was the end of the pay period.

The resulting formula was:

=INDEX('Data Sheet'!B$4:B$103,SMALL(IF(('Data Sheet'!A$4:A$103gt;=C$51)*('Data
Sheet'!A$4:A$103lt;=AF$51),ROW('Data Sheet'!A$4:A$103)-ROW('Data
Sheet'!A$4) 1),ROWS($1:1)))

Used CF to quot;hidequot; any errors.

Biff

quot;Biffquot; gt; wrote in message
...
gt; #NUM! would mean there are no matches.
gt;
gt; Send me an email..........if you can't send the file, just make a list of
gt; these entries:
gt;
gt; I need to know *EXACTLY* what you have in A4:A103, B4:B103, F51:AF51,
gt; F52:AF52, C51. Don't just tell me that you have dates! I need to know WHAT
gt; DATES!!!!!!!!!!
gt;
gt; My address is: xlcanhelpatcomcastperiodnet
gt;
gt; Remove quot;canquot; and change the obvious.
gt;
gt; Biff
gt;
gt; quot;ben simpsonquot; gt; wrote in message
gt; ...
gt;gt;I got the areas fixed that you pointed out. Now I get a #NUM error. i
gt;gt;need
gt;gt; guidance from here (obviously...hehehe). This is what it looks like.
gt;gt; In an array of course.
gt;gt;
gt;gt; =INDEX('Data Sheet'!B$4:B$103,SMALL(IF(('Data
gt;gt; Sheet'!A$4:A$103gt;=INDEX(F$51:AF$51,MATCH(C$51,F$51 :AF$51,1)))*('Data
gt;gt; Sheet'!A$4:A$103lt;=INDEX(F$52:AF$52,MATCH(C$51,F$51 :AF$51,1))),ROW('Data
gt;gt; Sheet'!A$4:A$103)-ROW('Data Sheet'!A$4) 1),ROWS($1:1)))
gt;gt;
gt;gt; Where does it go from here?.....Thanks....Ben
gt;gt;
gt;gt; quot;Biffquot; wrote:
gt;gt;
gt;gt;gt; This portion:
gt;gt;gt;
gt;gt;gt; lt;=INDEX(F$51:AF$52,MATCH(C$51,F$51:AF$51,1)))
gt;gt;gt;
gt;gt;gt; Should be:
gt;gt;gt;
gt;gt;gt; lt;=INDEX(F$52:AF$52,MATCH(C$51,F$51:AF$51,1)))
gt;gt;gt;
gt;gt;gt; Also, since there may be more than one match, when you copy the formula
gt;gt;gt; down
gt;gt;gt; you don't want these ranges to increment, do you?
gt;gt;gt;
gt;gt;gt; 'Data Sheet'!B4:B103
gt;gt;gt; 'Data Sheet'!A4:A103
gt;gt;gt;
gt;gt;gt; So, make the row references absolute:
gt;gt;gt;
gt;gt;gt; 'Data Sheet'!B$4:B$103
gt;gt;gt; 'Data Sheet'!A$4:A$103
gt;gt;gt;
gt;gt;gt; gt; I have no clue as to what you meant by error trap the formula. Can
gt;gt;gt; gt; you
gt;gt;gt; gt; clarify that for me?
gt;gt;gt;
gt;gt;gt; When you got the #REF! error, an error trap is a portion of the formula
gt;gt;gt; that
gt;gt;gt; quot;anticipatesquot; when errors will be generated and prevents them from being
gt;gt;gt; displayed. Let's get the basic formula working first then we'll deal
gt;gt;gt; with
gt;gt;gt; errors later!
gt;gt;gt;
gt;gt;gt; Biff
gt;gt;gt;
gt;gt;gt; quot;ben simpsonquot; gt; wrote in message
gt;gt;gt; ...
gt;gt;gt; gt; Yikes...you weren't kidding. I copied the formula down, and pasted it
gt;gt;gt; gt; in.
gt;gt;gt; gt; I
gt;gt;gt; gt; had to change the cell references to the correct sheet (sorry if I
gt;gt;gt; gt; wasn't
gt;gt;gt; gt; clear). Now it giving me a #REF error, and I don't know why. Here's
gt;gt;gt; gt; what
gt;gt;gt; gt; i
gt;gt;gt; gt; have now:
gt;gt;gt; gt; As an array.
gt;gt;gt; gt;
gt;gt;gt; gt; =INDEX('Data Sheet'!B4:B103,SMALL(IF(('Data
gt;gt;gt; gt; Sheet'!A4:A103gt;=INDEX(F$51:AF$51,MATCH(C$51,F$51:A F$51,1)))*('Data
gt;gt;gt; gt; Sheet'!A4:A103lt;=INDEX(F$51:AF$52,MATCH(C$51,F$51:A F$51,1))),ROW('Data
gt;gt;gt; gt; Sheet'!A4:A103)-ROW('Data Sheet'!A4) 1),ROWS($1:1)))
gt;gt;gt; gt;
gt;gt;gt; gt; I have no clue as to what you meant by error trap the formula. Can
gt;gt;gt; gt; you
gt;gt;gt; gt; clarify that for me?.....Thanks....Ben
gt;gt;gt; gt;
gt;gt;gt; gt;
gt;gt;gt; gt;
gt;gt;gt; gt;
gt;gt;gt; gt;
gt;gt;gt; gt; quot;Biffquot; wrote:
gt;gt;gt; gt;
gt;gt;gt; gt;gt; I told you this would be complicated!
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; I'm assuming that:
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; row 51 = start of period
gt;gt;gt; gt;gt; row 52 = end of period
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; Try this:
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; Entered as an array using the key combo of CTRL,SHIF,ENTER:
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; =INDEX(B$4:B$103,SMALL(IF((A$4:A$103gt;=INDEX(F$51:A F$51,MATCH(C$51,F$51:AF$51,1)))*(A$4:A$103lt;=INDEX( F$52:AF$52,MATCH(C$51,F$51:AF$51,1))),ROW(A$4:A$10 3)-ROW(A$4) 1),ROWS($1:1)))
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; Copy down until you get #NUM! errors. If you want an error trap the
gt;gt;gt; gt;gt; formula
gt;gt;gt; gt;gt; will be twice as long!!!!!!!!
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; Biff
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt; quot;ben simpsonquot; gt; wrote in message
gt;gt;gt; gt;gt; ...
gt;gt;gt; gt;gt; gt; Hi there.
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt; I've been working on is a time sheet (and almost done with it).
gt;gt;gt; gt;gt; gt; During
gt;gt;gt; gt;gt; gt; our work periods throught the year we accrue holidays (just like
gt;gt;gt; gt;gt; gt; vacation
gt;gt;gt; gt;gt; gt; time).
gt;gt;gt; gt;gt; gt; What I'm wanting to do is compare the present work period dates
gt;gt;gt; gt;gt; gt; (I
gt;gt;gt; gt;gt; gt; have
gt;gt;gt; gt;gt; gt; the dates in ms date format in F51:AF52), to a list that I manually
gt;gt;gt; gt;gt; gt; have
gt;gt;gt; gt;gt; gt; looked up of the holiday dates (this is in the ms date format in
gt;gt;gt; gt;gt; gt; A4:A103
gt;gt;gt; gt;gt; gt; on
gt;gt;gt; gt;gt; gt; the data sheet). In cell C28 on the time sheet, I need the name of
gt;gt;gt; gt;gt; gt; the
gt;gt;gt; gt;gt; gt; holiday and/or holidays that have accrued during the pay period
gt;gt;gt; gt;gt; gt; (thats
gt;gt;gt; gt;gt; gt; in
gt;gt;gt; gt;gt; gt; the
gt;gt;gt; gt;gt; gt; cell next to dates in B4:B103 on the data sheet). Hope I haven't
gt;gt;gt; gt;gt; gt; lost
gt;gt;gt; gt;gt; gt; you
gt;gt;gt; gt;gt; gt; yet.
gt;gt;gt; gt;gt; gt; What I have:
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt; Data Sheet
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt; 38718 New Years Day
gt;gt;gt; gt;gt; gt; 38733 Martin Luther King Jr. Day
gt;gt;gt; gt;gt; gt; 38768 Presidents Day
gt;gt;gt; gt;gt; gt; 38866 Memorial Day
gt;gt;gt; gt;gt; gt; 38902 Fourth of July
gt;gt;gt; gt;gt; gt; 38964 Labor Day
gt;gt;gt; gt;gt; gt; 39044 Thanksgiving Day
gt;gt;gt; gt;gt; gt; 39045 Day after Thanksgiving Day
gt;gt;gt; gt;gt; gt; 39075 Christmas Eve
gt;gt;gt; gt;gt; gt; 39076 Christmas Day
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt; What I've been using:
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt; =IF(ISNA(MATCH(F51:AF52,'Data
gt;gt;gt; gt;gt; gt; Sheet'!A4:A103,0)),quot;quot;,VLOOKUP(C51,'Data
gt;gt;gt; gt;gt; gt; Sheet'!A4:B103,2))
gt;gt;gt; gt;gt; gt; This only lists the last match that it finds, and not all the
gt;gt;gt; gt;gt; gt; matches,
gt;gt;gt; gt;gt; gt; which
gt;gt;gt; gt;gt; gt; is what I actually need.
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt; What I need (in C28) if the pay period was from 12/26/2005 thru
gt;gt;gt; gt;gt; gt; 01/21,2006:
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt; Accrued Holiday(s) For: New Years Day, Martin Luther King Jr.
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt; gt; I think this is possible, I'm not savvy enough in Excel to figure
gt;gt;gt; gt;gt; gt; this
gt;gt;gt; gt;gt; gt; out
gt;gt;gt; gt;gt; gt; on my own. This is way over my head. Any help is appreciated.
gt;gt;gt; gt;gt; gt; Thanks....Ben
gt;gt;gt; gt;gt; gt;
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt;
gt;gt;gt; gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;gt;gt;
gt;
gt;