Calculating number of days if each month has 28 days

[Orieus]

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!

 

[Rick Rothstein]

I have no idea if this is right or not, but based on your description, this is my guess...

=(YEAR(ENDDATE)-YEAR(STARTDATE))*336+(MONTH(ENDDATE)-MONTH(STARTDATE))*28+(IF(DAY(ENDDATE)>28,28,DAY(ENDDATE))-IF(DAY(STARTDATE)>28,28,DAY(STARTDATE)))+1

 

[Orieus]

I have no idea if this is right or not, but based on your description, this is my guess...

Rick, thank you so much for your speedy reply - I believe that this is exactly what I needed! I quickly tested it on a few different date scenarios and it gives the expected result. Thanks again!