| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
holiday dates
I want to be able to have excel determine last years holiday dates by looking at this years date which is entered in a cell. Example: Cell a1 is where a person would enter Memorial day 2006 Cell b1 would display last years memorial date I want to be able to do this with all the major and minor holidays New Year Easter Memorial day july 4th labor day thanksgiving christmas and possibly the jewish holidays as well. Any ideas?? I'm lost -- bucci ------------------------------------------------------------------------ bucci's Profile: http://www.excelforum.com/member.php...o&userid=34889 View this thread: http://www.excelforum.com/showthread...hreadid=546323 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to add dates. | Excel Worksheet Functions | |||
| need to convert list of dates to count no. of dates by week | Excel Worksheet Functions | |||
| VBA Function that ignores dates in a Holiday Table | Excel Worksheet Functions | |||
| Holiday Dates | Excel Worksheet Functions | |||
| Calculating number of days between two dates that fall between two other dates | Excel Discussion (Misc queries) | |||
Threaded Mode
