# Question regarding date formula

#### Azilan

##### New Member
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

### Excel Facts

Best way to learn Power Query?
Read M is for (Data) Monkey book by Ken Puls and Miguel Escobar. It is the complete guide to Power Query.
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?

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?

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

BTW the answer is 364 days.

Thanks it worked

Replies
1
Views
155
Replies
4
Views
520
Replies
0
Views
105
Replies
4
Views
391
Replies
4
Views
501

1,218,515
Messages
6,142,918
Members
450,455
Latest member
Handienak

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back