Thread: Second Friday
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
vezerid vezerid is offline
external usenet poster
 
Posts: 751
Default Second Friday

If this date is in A1 use:
=DATE(YEAR(A1),MONTH(A1),1)+13-MOD(DATE(YEAR(A1),MONTH(A1),1),7)

HTH
Kostis Vezerides

On Jan 26, 4:42 pm, "Deb" wrote:
Hello Everyone,

If I start with a specific date (01-08-07) how do I get to the second
friday date of the month of (01-19-07) using Excel?

Thanks