Friday is a weekend in France Ardus? I always knew you were civilized <bg

alternative

=IF(WEEKDAY(A1,2)5,"",DATE(YEAR(A1),MONTH(A1)+1,D AY(A1)))

Lara,

What happens when the calculated date is a weekend?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Ardus Petus" wrote in message
...
In B1, enter:
=IF(OR(WEEKDAY(A1)=1,WEEKDAY(A1)=6,"",DATE(YEAR(A1 ),MONTH(A1)+1,DAY(A1)))
then copy down

HTH
--
AP

"lara5555" a écrit
dans le message de
...

Hi,

I'm trying to get column B (dates) to be a copy of column A (same dates
but 1 month behind) and need to get the formula to ignore coloured cells
(weekends).. any ideas?


--
lara5555
------------------------------------------------------------------------
lara5555's Profile:
http://www.excelforum.com/member.php...fo&userid=2741
View this thread:
http://www.excelforum.com/showthread...hreadid=529519