rounding off month
 

You can try the following formula to determine if the date is before or after
the 15th.

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

You can substitute calculations in place of "15" and "<=15" for how you
want to calculate the depreciation now that you know whether the date is
before or after the 15th.

Hope this is a start.

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

rounding off month
 

Thank you all who have responded.
I have the formula I need.

Thanks once again
Simha


"William Horton" wrote in message
...
You can try the following formula to determine if the date is before or
after
the 15th.

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

You can substitute calculations in place of "15" and "<=15" for how you
want to calculate the depreciation now that you know whether the date is
before or after the 15th.

Hope this is a start.

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