R Ron Rosenfeld Nov 16, 2003 #21 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
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 Nov 16, 2003 #22 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.
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 Feb 15, 2004 #23 This should work =DATE(YEAR(NOW()),MONTH(NOW()),15)-MAX(0,WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW( )),15),2)-5)
This should work =DATE(YEAR(NOW()),MONTH(NOW()),15)-MAX(0,WEEKDAY(DATE(YEAR(NOW()),MONTH(NOW( )),15),2)-5)
