find date
 

I have a 'holiday' sheet with input holiday as follows:
23 Dec 2006
24 Dec 2006
25 Dec 2006
26 Dec 2006

My example is
If I type in 22 Dec. 2006 in cell A1. As 22 Dec 2006 is not fall on holiday,
the cell A1 shows 22 Dec. 2006 (remain unchange).
If I type in 23 Dec. 2006, the A2 cell will show 27 Dec 2006.

Is there any macro that could assist me to do this.

Thank you for your help

find date
 

Since the number of holidays is fairly small and probably only gets updated
annually, I'd create a table where the first column is the holiday and the
second column is the next workday. Then coverting from a given date (say in
A1) to the next workday is a pretty simple formula. If the table on the
worksheet Holidays, in columns A:B, the formula is
=if(isna(match(a1,Holidays!A:A,false)),a1,vlookup( a1,Holidays!A:B,2,false))
That is, if the date in question is not a holiday, no change; otherwise,
return the corresponding date from column B.
HTH. --Bruce

"Anna" wrote:

I have a 'holiday' sheet with input holiday as follows:
23 Dec 2006
24 Dec 2006
25 Dec 2006
26 Dec 2006

My example is
If I type in 22 Dec. 2006 in cell A1. As 22 Dec 2006 is not fall on holiday,
the cell A1 shows 22 Dec. 2006 (remain unchange).
If I type in 23 Dec. 2006, the A2 cell will show 27 Dec 2006.

Is there any macro that could assist me to do this.

Thank you for your help