day count

Hi there, I'm facing an issue and i don't even know if it's possible to fix. Context: I'm calculating allowances. The amount is per paid day, so I need to know how many days each employee has been in a country. While I know the total number of days. it's supposed to be a salary so I need...

Hi all, First, thanks for reading this and trying to help! Background: I have different travelers going to the same location at different dates. Sometimes these dates overlap, sometimes they don't. I'm looking for a formula that will calculate the number of 'unique' days spent in a location...

Hello, In excel I am trying to return a date given a "start date", "excluding holidays", and "a number of days for completion". For example, given the start date of 9/1/2015, 60 days for completion, excluding holidays, would be XX/XX/XXXX. The "WORKDAY.INTL" function would be great, but I do...

Hello, I am trying to calculate modified duration for an instrument that uses the day count convention BUS/252. BUS refers to the number of business days in the country (Brazil in my case - 246 BUS in 2015). How could I adjust the MDURATION function in Excel for this different day count...

Hi there! I'm a newbie on the forum and quite exctied to be part of the community. I'm having some trouble with a nested IF function in my spreadsheet. There are a few different parameters I'm attempting to incorporate, and there seems to be a problem somewhere. I'm no expert, so any help to...

How to get no. of YEARS, MONTHS & DAYS between 2 dates (both days inclusive). Thanks in adv

Dear all, I am having problems with returning the day of the year. I have tried a number of ways. This formula keeps reoccurring but it does not work for me. =A1-DATE(YEAR(A1),1,0) with todays date in A1. I am using Excel for Mac 2011. Can anyone help me?