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
 

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Brian from Maui

MrExcel MVP
Joined
Feb 16, 2002
Messages
8,458
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,458
Just subtracted one from the other and format as general. Assuming both dates are true date values.

BTW the answer is 364 days.
 

Watch MrExcel Video

Forum statistics

Threads
1,109,456
Messages
5,528,868
Members
409,842
Latest member
mfernandezcean
Top