Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello,
I am using a variable to delete rows in a large spreadsheet. Dim StartDate As Date Dim EndDate As Date StartDate = Now EndDate = Workday(StartDate, 1) I need to change EndDate so that whatever StartDate is, EndDate is the 2nd Friday after that, unless StartDate is a Friday, in which case I need EndDate to be the 1st Friday after that. Can anybody change my verbage into the code needed? I've been struggling with it for awhile now. Many thanks in advance! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Exel increment date problem wrt todays date. | Excel Worksheet Functions | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
Us date versus EU date problem | Excel Programming | |||
Date problem | Excel Discussion (Misc queries) | |||
Date Problem | Excel Programming |