payday formula

R

Ron Rosenfeld

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


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


--ron
 
D

David Turner

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

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.
Click to expand...

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.
 
P

Peo Sjoblom

This should work

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