Home |
Search |
Today's Posts |
#1
|
|||
|
|||
rounding off month
=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 |
#2
|
|||
|
|||
rounding off month
If the date is in A2, then =date(year(a2),month(a2)+if(day(a2)15,1,0),1)
will calculate the first day of either this month or next. HTH. --Bruce "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 |
#3
|
|||
|
|||
rounding off month
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Working days left in the month compared to previous months | Excel Worksheet Functions | |||
formula: First and last day in month | Excel Worksheet Functions | |||
Month Year Date Format | Excel Worksheet Functions | |||
Accounting Month vs. Calendar Month | Excel Worksheet Functions | |||
How to extract month number from month name | Excel Discussion (Misc queries) |