not tested
=DAYS360(E11,E10)+(5*(YEAR(E10)-YEAR(E11)))

--
Don Guillett
SalesAid Software

"Paige" wrote in message
...
Is there a way to tell Excel (in VB or otherwise) to calculate the
difference
between 2 dates based solely upon 365 days a year, ignoring whether it is
a
leap year or not? I researched various VB/Excel sites and the internet,
and
couldn't find an answer to this.