The DAY function

Share on facebook
Share on twitter
Share on linkedin
Share on telegram
Share on whatsapp


The DAY function <Article <Blog | SumProduct are Excel training experts: financial modeling, strategic data modeling, model audit, planning and strategy, training courses, tips and online knowledge base

keep in mind javascript is required for full website functionality.

Welcome back to our regular blog of Excel functions from A to Z. Today we look at the DÍA function.

The DAY function

Esta función devuelve el día de una fecha, representado por un número de serie. The day se da como un número entero comprendido entre 1 Y 31.

The DÍA The function uses the following syntax to operate:

The DÍA The function has the following arguments:

  • serial number: This is required. La fecha del día que está intentando encontrar. Dates must be entered using the DATE function, or as a result of other formulas or functions. For instance, use DATE (2008,5,23) For the day 23 May 2008. Problems can arise if dates are entered as text.

It should also be noted that:

  • Microsoft Excel stores dates as sequential serial numbers so they can be used in calculations. By default, the 1 of January of 1900 is the serial number 1 and the 1 of January of 2008 is the serial number 39448 because it is 39,447 days after 1 of January of 1900.
  • Valores devueltos por AÑO, MES Y DÍA Las funciones serán valores gregorianos independientemente del formato de visualización del valor de fecha proporcionado. For instance, si el formato de visualización de la fecha proporcionada es Hijri, los valores devueltos para la AÑO, MES Y DÍA las funciones serán valores asociados con la fecha gregoriana equivalente.


Please, see my example below:


Soon we will continue with our functions from A to Z of Excel. Keep checking: there is a new blog post every business day.

You can find a full page of feature articles here.

Subscribe to our Newsletter

We will not send you SPAM mail. We hate it as much as you.