Question regarding date formula

Azilan

New Member
Joined
Jan 26, 2006
Messages
30
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

Formula for Yesterday
Name Manager, New Name. Yesterday =TODAY()-1. OK. Then, use =YESTERDAY in any cell. Tomorrow could be =TODAY()+1.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
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

New Member
Joined
Jan 26, 2006
Messages
30
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

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,459
Just subtracted one from the other and format as general. Assuming both dates are true date values.

BTW the answer is 364 days.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,168,127
Messages
5,857,525
Members
431,883
Latest member
Hien

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?

Disable AdBlock

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
Top