| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find Specific date in Biwwekly Based on date | Excel Discussion (Misc queries) | |||
| Julian date - find next highest date/number | Excel Worksheet Functions | |||
| Find the date of the coming up Saturday given the current date. | Excel Worksheet Functions | |||
| Using variables to make a date and using find method to find that. | Excel Programming | |||
| Find date and copy range based on that date | Excel Programming | |||
Threaded Mode
