Workday

[Guest]

Try
=IF(WEEKDAY(G4-43)=5,G4-43,IF(WEEKDAY(G4-43)>5,G4-43-
(WEEKDAY(G4-43)-5),G4-43+(5-WEEKDAY(G4-43))-7))

Hope this helps

-----Original Message-----
Hi, group--

Can someone please tell me how I would accomplish the following?
G4-43=x

G4 = 12/16/04
minus 43 days = 11/3/04

BUT , I would like 11/3/04 to move to the nearest

THURSDAY (backwards, not forwards, so my result SHOULD
BE: 10/28/04