Hi all
I've looked all over the internet but can't find what I'm looking for.
How workday works:
=Workday(A1,3) returns the date of the 3rd workday after the date in A1.
What I need:
How can I get the date of the 3rd weekend day?
it might look something like this:
=weekendday(A1,3)
eg:
If A1 contains Friday 20/08/2010, and I want the 3rd weekend day, I would get Saturday 28/08/2010.
Anyone? Much appreciated.
Guy
excel 2007 xp professional
I've looked all over the internet but can't find what I'm looking for.
How workday works:
=Workday(A1,3) returns the date of the 3rd workday after the date in A1.
What I need:
How can I get the date of the 3rd weekend day?
it might look something like this:
=weekendday(A1,3)
eg:
If A1 contains Friday 20/08/2010, and I want the 3rd weekend day, I would get Saturday 28/08/2010.
Anyone? Much appreciated.
Guy
excel 2007 xp professional