Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old November 3rd 04, 06:53 AM
iboock
 
Posts: n/a
Default 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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
UserForm to select current month or earlier Steve Excel Discussion (Misc queries) 2 January 21st 05 09:41 PM
How to extract month number from month name PM Excel Discussion (Misc queries) 2 January 19th 05 03:07 PM
Summarizing of columns for different days of month Charles Excel Discussion (Misc queries) 4 January 18th 05 04:07 PM
I need to create pivot table for the month but data in days Mikeyh133 Excel Discussion (Misc queries) 2 December 31st 04 07:53 PM
Days of the Month Chip1035 Excel Worksheet Functions 3 October 30th 04 03:58 AM


All times are GMT +1. The time now is 03:01 AM.

Powered by vBulletin® Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017