{"id":13915,"date":"2025-07-15T13:34:47","date_gmt":"2025-07-15T13:34:47","guid":{"rendered":"https:\/\/functiontranslator.com\/dias360\/"},"modified":"2021-02-26T08:45:09","modified_gmt":"2021-02-26T08:45:09","slug":"days360","status":"publish","type":"post","link":"https:\/\/functiontranslator.com\/es\/days360\/","title":{"rendered":"DIAS360"},"content":{"rendered":"

Descripci\u00f3n General<\/h2>\n

La funci\u00f3n DAYS360<\/code> (o DIAS360<\/code> en espa\u00f1ol) calcula el n\u00famero de d\u00edas entre dos fechas bas\u00e1ndose en un a\u00f1o est\u00e1ndar de 360 d\u00edas. Este m\u00e9todo es especialmente \u00fatil en el \u00e1mbito de la contabilidad financiera, donde simplifica el c\u00e1lculo de intereses durante un per\u00edodo determinado.<\/p>\n

Sintaxis y Ejemplos<\/h2>\n

La sintaxis para utilizar DAYS360<\/code> es la siguiente:<\/p>\n

=DIAS360(fecha_inicial, fecha_final, [m\u00e9todo])<\/code><\/pre>\n
    \n
  • fecha_inicial:<\/b> La fecha de inicio del per\u00edodo.<\/li>\n
  • fecha_final:<\/b> La fecha de fin del per\u00edodo.<\/li>\n
  • m\u00e9todo (opcional):<\/b> Un valor booleano que determina si se utiliza el m\u00e9todo de calendario estadounidense (falso por defecto) o el m\u00e9todo de calendario europeo (verdadero).<\/li>\n<\/ul>\n
    Ejemplo 1: Calcula el n\u00famero de d\u00edas entre el 1 de enero y el 31 de diciembre de 2023 usando el m\u00e9todo estadounidense:<\/p>\n
    =DIAS360(\"01\/01\/2023\", \"31\/12\/2023\")<\/code><\/pre>\n
    Esto resulta en 360 d\u00edas.<\/p>\n
    Ejemplo 2: Usando el m\u00e9todo europeo para el mismo per\u00edodo:<\/p>\n
    =DIAS360(\"01\/01\/2023\", \"31\/12\/2023\", VERDADERO)<\/code><\/pre>\n
    El resultado tambi\u00e9n ser\u00eda 360 d\u00edas, aunque la metodolog\u00eda para contar los d\u00edas var\u00eda ligeramente, sobre todo en fechas de fin de mes.<\/p>\n
    Aplicaciones Pr\u00e1cticas<\/h2>\n
    Primer Escenario: C\u00e1lculo de intereses en un pr\u00e9stamo<\/h2>\n
    Para calcular los intereses sobre un pr\u00e9stamo con una tasa anual del 5%, basado en un a\u00f1o financiero de 360 d\u00edas, desde el 1 de marzo de 2023 hasta el 1 de marzo de 2024, la f\u00f3rmula ser\u00eda:<\/p>\n
    =TASA_ANUAL\/360*DIAS360(\"01\/03\/2023\", \"01\/03\/2024\")*MONTO_DEL_PRESTAMO<\/code><\/pre>\n
    Si la tasa anual es del 5% y el monto del pr\u00e9stamo es de 1000 d\u00f3lares, el c\u00e1lculo ser\u00eda:<\/p>\n
    =0.05\/360*360*1000<\/code><\/pre>\n
    Esto resultar\u00eda en 50 d\u00f3lares de intereses acumulados.<\/p>\n
    Segundo Escenario: Planificaci\u00f3n y presupuestaci\u00f3n de proyectos<\/h2>\n
    En la gesti\u00f3n de proyectos, es crucial calcular la duraci\u00f3n exacta entre dos fechas para establecer los plazos y presupuestos adecuados. Para un proyecto que se extiende del 1 de febrero al 1 de agosto de 2023, se configurar\u00eda as\u00ed:<\/p>\n
    =DIAS360(\"01\/02\/2023\", \"01\/08\/2023\")<\/code><\/pre>\n
    Esto proporcionar\u00e1 un total de 180 d\u00edas, facilitando una planificaci\u00f3n precisa bajo el est\u00e1ndar de un a\u00f1o financiero convencional.<\/p>\n","protected":false},"excerpt":{"rendered":"
    Calcula el n\u00famero de d\u00edas entre dos fechas a partir de un a\u00f1o de 360 d\u00edas<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[546],"tags":[],"class_list":["post-13915","post","type-post","status-publish","format-standard","hentry","category-fecha-y-hora"],"acf":[],"yoast_head":"\nFunci\u00f3n DAYS360 (DIAS360) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis<\/title>\n<meta name=\"description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DAYS360 (DIAS360) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/functiontranslator.com\/es\/days360\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Funci\u00f3n DAYS360 (DIAS360) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta property=\"og:description\" content=\"Explicaci\u00f3n breve de la funci\u00f3n DAYS360 (DIAS360) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/functiontranslator.com\/es\/days360\/\" \/>\n<meta property=\"og:site_name\" content=\"Function Translator\" \/>\n<meta property=\"article:published_time\" content=\"2025-07-15T13:34:47+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-02-26T08:45:09+00:00\" \/>\n<meta name=\"author\" content=\"glavadmin\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:title\" content=\"Funci\u00f3n DAYS360 (DIAS360) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\" \/>\n<meta name=\"twitter:label1\" content=\"Escrito por\" \/>\n\t<meta name=\"twitter:data1\" content=\"glavadmin\" \/>\n\t<meta name=\"twitter:label2\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/functiontranslator.com\/es\/days360\/\",\"url\":\"https:\/\/functiontranslator.com\/es\/days360\/\",\"name\":\"Funci\u00f3n DAYS360 (DIAS360) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis\",\"isPartOf\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\"},\"datePublished\":\"2025-07-15T13:34:47+00:00\",\"dateModified\":\"2021-02-26T08:45:09+00:00\",\"author\":{\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\"},\"description\":\"Explicaci\u00f3n breve de la funci\u00f3n DAYS360 (DIAS360) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.\",\"breadcrumb\":{\"@id\":\"https:\/\/functiontranslator.com\/es\/days360\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/functiontranslator.com\/es\/days360\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/functiontranslator.com\/es\/days360\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Excel functions\",\"item\":\"https:\/\/functiontranslator.com\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Fecha y hora\",\"item\":\"https:\/\/functiontranslator.com\/es\/fecha-y-hora\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"DIAS360\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#website\",\"url\":\"https:\/\/functiontranslator.com\/no\/\",\"name\":\"Function Translator\",\"description\":\"Excel function translator\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/functiontranslator.com\/no\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389\",\"name\":\"glavadmin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g\",\"caption\":\"glavadmin\"},\"sameAs\":[\"https:\/\/functiontranslator.com\"],\"url\":\"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Funci\u00f3n DAYS360 (DIAS360) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","description":"Explicaci\u00f3n breve de la funci\u00f3n DAYS360 (DIAS360) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/functiontranslator.com\/es\/days360\/","og_locale":"es_ES","og_type":"article","og_title":"Funci\u00f3n DAYS360 (DIAS360) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","og_description":"Explicaci\u00f3n breve de la funci\u00f3n DAYS360 (DIAS360) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","og_url":"https:\/\/functiontranslator.com\/es\/days360\/","og_site_name":"Function Translator","article_published_time":"2025-07-15T13:34:47+00:00","article_modified_time":"2021-02-26T08:45:09+00:00","author":"glavadmin","twitter_card":"summary_large_image","twitter_title":"Funci\u00f3n DAYS360 (DIAS360) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","twitter_misc":{"Escrito por":"glavadmin","Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/functiontranslator.com\/es\/days360\/","url":"https:\/\/functiontranslator.com\/es\/days360\/","name":"Funci\u00f3n DAYS360 (DIAS360) en Excel \u2013 c\u00f3mo funciona, ejemplos y sintaxis","isPartOf":{"@id":"https:\/\/functiontranslator.com\/no\/#website"},"datePublished":"2025-07-15T13:34:47+00:00","dateModified":"2021-02-26T08:45:09+00:00","author":{"@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389"},"description":"Explicaci\u00f3n breve de la funci\u00f3n DAYS360 (DIAS360) de Excel. Consulta la sintaxis, par\u00e1metros y ejemplos de uso.","breadcrumb":{"@id":"https:\/\/functiontranslator.com\/es\/days360\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/functiontranslator.com\/es\/days360\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/functiontranslator.com\/es\/days360\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Excel functions","item":"https:\/\/functiontranslator.com\/es\/"},{"@type":"ListItem","position":2,"name":"Fecha y hora","item":"https:\/\/functiontranslator.com\/es\/fecha-y-hora\/"},{"@type":"ListItem","position":3,"name":"DIAS360"}]},{"@type":"WebSite","@id":"https:\/\/functiontranslator.com\/no\/#website","url":"https:\/\/functiontranslator.com\/no\/","name":"Function Translator","description":"Excel function translator","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/functiontranslator.com\/no\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Person","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/87663eece497ca58643166ecb09f1389","name":"glavadmin","image":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/functiontranslator.com\/no\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/03ccd9347c5339db75deede5a8c5b2bf1d40e0bce26a5251fcaac6331d381db8?s=96&d=mm&r=g","caption":"glavadmin"},"sameAs":["https:\/\/functiontranslator.com"],"url":"https:\/\/functiontranslator.com\/es\/author\/glavadmin\/"}]}},"_links":{"self":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13915","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/comments?post=13915"}],"version-history":[{"count":2,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13915\/revisions"}],"predecessor-version":[{"id":29978,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/posts\/13915\/revisions\/29978"}],"wp:attachment":[{"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/media?parent=13915"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/categories?post=13915"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/functiontranslator.com\/es\/wp-json\/wp\/v2\/tags?post=13915"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}