payday formula

[Ron Rosenfeld]

Definitely not. Sorry if I wasn't clear. If the 15th falls on a weekend,
checks are always issued on Friday.

That's different from saying: "checks come on the closest weekday".


--ron

 

[David Turner]

Ron Rosenfeld wrote

In your OP, you wrote "checks come on the closest weekday." And that
was how I responded.

In a followup to Bob Phillips, I wrote:
"To clarify, if the 15th of the month falls on Sat or Sun, check arrives
the Fri before that, the 14th or 13th."

If you really meant the preceding weekday, then Peo's formula would be
appropriate.

It does indeed meet my needs.

Don't take offense. I really do appreciate the time and effort you put into
trying to provide an alternate solution.

 

[Peo Sjoblom]

This should work

=DATE(YEAR(NOW()),MONTH(NOW()),15)-MAX(0,WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW(
)),15),2)-5)