Find Pay Date from date sold (Friday of following week)

[dmarzean]

Hello all!

I have searched and couldn't quite find what I was looking for. What I need is:

If a sale was made between 2/09/2014 - 2/15/2014 return the date of the following weeks Friday. In this case 02/21/2014.

Thanks,

[Olly]

Try:

Please Login or Register  to view this content.

That assumes that your week starts on a Sunday, and for a Sunday you want the FOLLOWING week... e.g. Purchase made on Sunday 16th Feb returns Friday 28th Feb.

[dmarzean]

Thank you for the fast reply. This is not working. 02/16/2014 returns 02/22/2014 02/17/2014 returns 02/23/2014.

I need any date between 02/16/2014 - 02/22/2014 to return 02/28/2014

Thanks

[dmarzean]

Never mind works perfect. I miss typed....

Thank you much.