| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
worksheet funtion help
I understand that this goes in the vb code but I don't understand on how to
make it work. All my formulas for my holidays are in the form of Worksheet Formulas on Sheet3, Column A. How would I add this formula to say Sheet3, cell A26. Public Function ThanksgivingDate(Yr As Integer) As Date ThanksgivingDate = DateSerial(Yr, 11, 29 - _ WeekDay(DateSerial(Yr, 11, 1), vbFriday)) End Function Thanks in advance!!! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Search one worksheet for values in another worksheet? | Excel Discussion (Misc queries) | |||
| Worksheet not showing up in VBE | Excel Worksheet Functions | |||
| Search/Match between 2 x separate Worksheets and populate result in third worksheet | Excel Discussion (Misc queries) | |||
| Copy from worksheet to another x times | Excel Discussion (Misc queries) | |||
| Weekly Transaction Processing | Excel Worksheet Functions | |||
Threaded Mode
