What is the date of the second Friday of Mar 2003

  • Thread starter Joseph M. Yonek
  • 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
 
D

Daniel.M

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Using a Date and corresponding weekday to pull amounts 1
Finding the previous Saturday, then Friday date 3
Military Rate/Rank Formula 1
Deriving an earlier date based on a later date 7
IF statement based on True/False that activates a certain list box 1
Calculate the date of the next Friday dependent on the current dat 2
Pls Help - blank cell/formula issue 7
Find "Last Friday" function works almost 100% 10

Top