What is the date of the second Friday of Mar 2003

  • Thread starter Thread starter Joseph M. Yonek
  • Start date Start date
J

Joseph M. Yonek

I need to create a formula that is going to calculate the date based on
knowing that a transaction occurs on the second Friday, third Tuesday, ect.

Any ideas?

Thanks again for the great insights that everyone provides.

Joe
 
Hi Joseph,

=DATE(YR,Mth,1+7*Nth)-WEEKDAY(DATE(YR,Mth,8-DOW))

For the second Friday of Mar 2003:
YR= 2003
Mth= 3
DOW= 6 ' cause Sunday =1, Monday =2, ..., Saturday = 7
Nth= 2

When Nth=5, you need to do a test if the specific month has 5 DOW.
Let me know if that is a possibility.

Regards,

Daniel M.
 
Back
Top