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
|