Excel calculations on dates
Closed
egeuens
-
Mar 16, 2011 at 03:03 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2011 at 09:58 AM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 17, 2011 at 09:58 AM
Related:
- Excel calculations on dates
- Excel free download - Download - Spreadsheets
- Excel marksheet - Guide
- Number to words in excel - Guide
- Excel date format dd.mm.yyyy - Guide
- How to screenshot on excel - Guide
3 responses
RWomanizer
Posts
365
Registration date
Monday February 7, 2011
Status
Contributor
Last seen
September 30, 2013
120
Mar 16, 2011 at 07:26 AM
Mar 16, 2011 at 07:26 AM
it is better to put a column w.r.t. each year and than use datedif,
otherwise you have to use lots of if statement.
otherwise you have to use lots of if statement.
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 17, 2011 at 08:37 AM
Mar 17, 2011 at 08:37 AM
what you mean by days between days. Do you mean to seek number of days between two dates (in which case datediff would have worked with parameter "d")
If you mean to have number of days between two days but grouped separetely for each year, then it becomes bit more complicated
If you mean to have number of days between two days but grouped separetely for each year, then it becomes bit more complicated
egeuens
Posts
1
Registration date
Thursday March 17, 2011
Status
Member
Last seen
March 17, 2011
Mar 17, 2011 at 09:45 AM
Mar 17, 2011 at 09:45 AM
Hi,
Indeed I need the number of days per year, grouped.
Any idea how to realize it?
Thx
Erwin
Indeed I need the number of days per year, grouped.
Any idea how to realize it?
Thx
Erwin
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Mar 17, 2011 at 09:58 AM
Mar 17, 2011 at 09:58 AM
Since you say that at the end of all this, what you care is have a total interest payable between days. Taking into account for each year interest rate is different, the best solution in my opinion would be that you write a custom function. In a sheet or may be even in the function you can put the interest values for the year and let that custom function get the days for each and add up all the amount to give you the final answer