| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
days360
then just format the cell as General and use
=A2-A1 keng wrote: I am attemting to copy a digital countdown calendar. I assumed that the 652 days left was correct. Thanks "Bob I" wrote: 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 21months*30days+12days=642 How did you get 652? keng wrote: Days360 is coming up a few days short. This is what I have A 1 today() 2 1/1/2010 3 =days360(a1,a2) it is giving me 642 and I believe that it should be 652 Any suggestions? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| DAYS360 | Excel Worksheet Functions | |||
| DAYS360 | Excel Worksheet Functions | |||
| networkdays vs days360 | Excel Discussion (Misc queries) | |||
| =DAYS360 | Excel Discussion (Misc queries) | |||
| DAYS360 | Excel Worksheet Functions | |||
Hybrid Mode
