Hi all,

examples of what I need, can someone assist?

Date provided = 21/05/06
I need excel to provide the date: 22/04/06

Date provided = 31/07/06
I need excel to provide the date: 01/07/06

Date provided = 01/06/06
I need excel to provide the date: 02/05/06


Thanks


--
wfactor
------------------------------------------------------------------------
wfactor's Profile: http://www.excelforum.com/member.php...o&userid=35548
View this thread: http://www.excelforum.com/showthread...hreadid=553104