Payday comes on the 1st and 15th, but if one of those days is on a weekend
the payday is the friday before that weekend. I have to have certain days
for each month depending on if payday is on a weekend or not.

Sandy Mann wrote:
Travis,

What determins when it is payday? Is it every two weeks? Certain weekdays
after certain dates in the month? Or what?

I'm trying to create a formula and need help or hints on how to do this.
What I would like to do is: in cell A1 have the word PAYDAY appear on
[quoted text clipped - 4 lines]
a
month). Any help or questions on this is highly appreciated.

--
Thanks,
T_Sr

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200601/1