Thread: Date problem
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Melvin Purvis[_2_] Melvin Purvis[_2_] is offline
external usenet poster
 
Posts: 3
Default Date problem

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!