Firstly, please forgive my Excel ignorance!
For several years we've been operating on a policy of each month having 30 days, and the year having 360 days. The following forumula was used to work out the number of days between two dates:
=(YEAR(ENDDATE)-YEAR(STARTDATE))*360+(MONTH(ENDDATE)-MONTH(STARTDATE))*30+(IF(DAY(ENDDATE)=31,30,DAY(ENDDATE))-IF(DAY(STARTDATE)=31,30,DAY(STARTDATE)))+1
However, for some reason it has now been changed to each month having just 28 days, and 336 days in a year (ridiculous I know).
I thought it would be easy to just amend, but it tells me that I've entered too many arguments for this function. I guess I need to insert additional parenthesis?
Alternatively, if you're able to suggest an alternative to that very long string, that would also be greatly appreciated, thank you!
For several years we've been operating on a policy of each month having 30 days, and the year having 360 days. The following forumula was used to work out the number of days between two dates:
=(YEAR(ENDDATE)-YEAR(STARTDATE))*360+(MONTH(ENDDATE)-MONTH(STARTDATE))*30+(IF(DAY(ENDDATE)=31,30,DAY(ENDDATE))-IF(DAY(STARTDATE)=31,30,DAY(STARTDATE)))+1
However, for some reason it has now been changed to each month having just 28 days, and 336 days in a year (ridiculous I know).
I thought it would be easy to just amend, but it tells me that I've entered too many arguments for this function. I guess I need to insert additional parenthesis?
Alternatively, if you're able to suggest an alternative to that very long string, that would also be greatly appreciated, thank you!