| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
how do i change days in a year to 365
How do I chage Excel's standard of 360 days in a year to be 365, for
functions such as Days360 and other methods of figuring out how many days occur between 2 dates? |
|
#2
|
|||
|
|||
|
The number of days between two dates can be calculated by direct subtraction.
For example, if A1 contains 1/1/2004 and A2 contains 1/1/2005 and you enter the formula =A2-A1 in another cell, the result will be 366 (formated as an integer). -- Gary's Student "tripjules" wrote: How do I chage Excel's standard of 360 days in a year to be 365, for functions such as Days360 and other methods of figuring out how many days occur between 2 dates? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DOnt calculate leap year | Excel Worksheet Functions | |||
| interest calcs using 365 days in a year | Excel Discussion (Misc queries) | |||
| conditional cell shading when a change occurs | Excel Discussion (Misc queries) | |||
| How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions | |||
| Help! I am stuck calculating Days, Hours, Mins please help | Excel Worksheet Functions | |||
Linear Mode
