Depreciation of fixed asset

I'm trying to calculate the Depreciation of the fixed asset for some items
I've tried the formulas that came with Excel but i don't know its not working or not give the correct value
so I attached a file as an example
what I'm trying to have is
1- straight line method along the asset life
2- salvage must be ( 1 )
3- if the purchase date is equal to or before the middle of the month (14-15/02/2004) so the start of depreciation have to start from the beginning of the current month ( Feb) but if the date excess the day 15 ( 16/02/2004) the middle of the month , the the depreciation must start from the next month.
so any one can help ?

I'm not quite I understand how you want to apply your Salvage and/or your End Dates in the sample mean the assets are all fully depreciated but perhaps:

E2: =DATE(YEAR(D2),MONTH(D2)+(DAY(D2)>15),1)
G2: =MIN(C2-1,(C2/DATEDIF(E2,F2,"m"))*DATEDIF(E2,MIN(F2,TODAY()),"m"))
H2: =C2-G2

Copied down for other rows.

Originally Posted by DonkeyOte

I'm not quite I understand how you want to apply your Salvage and/or your End Dates in the sample mean the assets are all fully depreciated but perhaps:

E2: =DATE(YEAR(D2),MONTH(D2)+(DAY(D2)>15),1)
G2: =MIN(C2-1,(C2/DATEDIF(E2,F2,"m"))*DATEDIF(E2,MIN(F2,TODAY()),"m"))
H2: =C2-G2

Copied down for other rows.

ok I changed the dates and made it in 2008 but still the current value is the same

**P.S. the date formula is working so well thank u

I don't understand your point, the last depreciation date for each asset is in the past (we're in 2009!) so they're all fully depreciated (less salvage value).

So just to finalise are you saying you only depreciate annually - I don't understand the significance of Last Depreciation Date otherwise.