Presuming that, for consistency with the other 2 examples,
the date needed in your lines:

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

is 02/07/06

then this would suffice ..

Assuming source dates are in A1 down
In B1: =DATE(YEAR(A1),MONTH(A1)-1,DAY(A1)+1)
Copy B1 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"wfactor" wrote:

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