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