=IF(DAY(A1)<16,1,0)

will return 1 if the day of the date in A1 is 15 or less.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"simha" wrote in message
...
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