Question regarding date formula

[Azilan]

Good Day

Operating System: Windows XP
Office package: Office 2003.

Question: When using the date formula days360 why does it work on 360 days and not 365?

Also how can one amend this formula (or is there another formula that can be used?) to indicate 365 days instead.

Thanks

 

[Brian from Maui]

From the Help files,

Returns the number of days between two dates based on a 360-day year (twelve 30-day months), which is used in some accounting calculations. Use this function to help compute payments if your accounting system is based on twelve 30-day months.

Care to explain what you're trying to do and what formula you're using?

 

[Azilan]

A user contacted me (I am from IT Support in my company) and stated that he wants a formula that will take into consideration the fact that not all months have 30 days - he basically wants the correct amount of days indicates if he were to deduct one date from another e.g. if 31 December is deducted from 01 January it must indicate 365 and not 360 days.

So it appears that unless you are an accountant this formula is not going to work/be valid for any other date calculations that are required.

Any way to get around this problem?

 

[Brian from Maui]

Just subtracted one from the other and format as general. Assuming both dates are true date values.

BTW the answer is 364 days.

 

[Azilan]

Thanks it worked