Forum Discussion
Solved
Obtener el mes actual y los anteriores
Saludos a todos. Tengo el siguiente problema, digamos que en la celda a100 deseo obtener el año y el mes actual; lo cual hago con la formula =TEXTO(HOY();"yyyy/mm"), el problema es que no se que hace...
a7024782 But the way you described it A100 has a TEXT formula withthe HOY() function (i.e. TODAY() in English) in it.
If A100 has a "regular" date like 19/02/2023, I would use a custom format yyyy/mm to display 2023/02 and then in A99 use:
=EDATE(A100,-1) and use the same custom format.
In Spanish that would be:
=FECHA.MES(A100;-1)
a7024782 But the way you described it A100 has a TEXT formula withthe HOY() function (i.e. TODAY() in English) in it.
If A100 has a "regular" date like 19/02/2023, I would use a custom format yyyy/mm to display 2023/02 and then in A99 use:
=EDATE(A100,-1) and use the same custom format.
In Spanish that would be:
=FECHA.MES(A100;-1)
Gracias, tome la sugerencia e hice las correcciones y funciona muy bien