Search

Module:Editor

Version:2.2.1 + (Deprecated as of version 24.02)

Type:Long or Double

Category:Date

 

Description

The formula 'Days360' returns the number of days between two dates based on a 360 day year. The formula assumes that every month has 30 days. The formula counts the number of days from the start date to the end date (the end date is not included). If the start date equals the end date the result will be 0, except if it is the 31st of the month. In this case the result will be 1.

This formula is deprecated as of version 24.02 and is no longer supported. Instead you should utilize the Days360Excel function with the parameter "Method" set to True, since this will give the same result. This change in formula will be automatically executed when opening the file in a new version.

Parameters

Start_date:

This is the date where it start counting the days.

End_date:

This is the date that it stop counting the days.

Example

Description

Below here you will find some examples of the 'Days360' formula:

 

Start_date:

1-1-2013

End_date:

30-1-2013

Result:

29

 

Start_date:

1-1-2013

End_date:

31-1-2013

Result:

29

 

Start_date:

1-1-2013

End_date:

1-2-2013

Result:

30

 

Start_date:

1-1-2013

End_date:

1-3-2013

Result:

60

Related Topics

Days360Excel: The formula 'Days360Excel' returns the number of days between two dates based on a 360 day year using the Microsoft Excel calculation method.

Feedback

If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.

Updated: 2014-09-23