BRILLIANT! Thanks.
-----Original Message-----
Hi
forgot to mention that you have to enter this as array
formula with
CTRL+SHIFT+ENTER and that it does not take care of
holidays
--
Regards
Frank Kabel
Frankfurt, Germany
"Frank Kabel" schrieb im
Newsbeitrag
...
Hi
if you put your data in A1 try:
=A1-SMALL(IF((WEEKDAY(A1-(ROW(INDIRECT("1:"&30*10))),2)
<7),ROW(INDIRECT
("1:"&30*10))),30)
--
Regards
Frank Kabel
Frankfurt, Germany
"KENNY" schrieb
im Newsbeitrag
...
Hi All,
I would like to put a date in one cell, while in the
other, show the date that is 30 days earlier -- but
not
counting Sundays. In other words, I have to have
something at this destination on date B, then I must
mail
it on Date A...
Help?!
.
|