You could use the following formula to determine if the day of the month is
before or after the 15th.

=IF(DAY(E16)15,"15","<=15")

You can substitute whatever calculations you want in place of "15" and
"<=15" to do the depreciation calculations that you need.

Hope this helps.

Bill Horton

"simha" wrote:

Hi,

I need to calculate depreciation based on months or part thereof.

For eg. if the asset is bought before 15 of May, then May is taken as full
month.
However it the asset is bough on 16th or later during May, then May month is
ignored.
Is there a formula for this?

Thanks in advance for any help

Regards
Simha