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
|