Count Days excluding Sundays

[KENNY]

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?!

 

[Frank Kabel]

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)

 

[Frank Kabel]

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

 

[KENNY]

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



.