ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How to Set a fix # of days per month (https://www.excelbanter.com/excel-worksheet-functions/5575-how-set-fix-days-per-month.html)

iboock

How to Set a fix # of days per month
 

Hey there,

I hope one of you can help me on this issue. I would like to calcualte
some financial calculations but I would like to have the formulas
(PV,PMT,IRR etc) use a predefine fix number of days per month.

In other words if I calculate PMT I would like to have an option of
defining either 30 or 31 days per month.
Any Ideas?


--
iboock
------------------------------------------------------------------------
iboock's Profile: http://www.excelforum.com/member.php...o&userid=16013
View this thread: http://www.excelforum.com/showthread...hreadid=274789



All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com