"SJT" wrote in message
...
a formula that will recognize that the month of June has 30 days and the
depreciation should be 7/30 of the full amount?

With the acquired date in H10 try:
=DAY(H10)/DAY(DATE(YEAR(H10),MONTH(H10)+1,0))
to give 7/30

acquired on 6/7/2006 and it expires in 10 years what is the easiest way to
simply add 120 months to the date of 6/7/2006?
To add 10 years use:
=DATE(YEAR(H10)+10,MONTH(H10),DAY(H10))

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


with @tiscali.co.uk