Forum Discussion

jdtobon88's avatar
jdtobon88
Helper I
6 years ago
Solved

get name next months

I need your help

 

you need to get the following month from the current date for the following 12 months:

I used the dateadd function but it is very strange because I don't calculate for the month of December

 

Example:

 

MesX1X2X3X4X5X6X7X8X9
enerofebreromarzoabrilmayonesajunio    
febreromarzoabrilmayonesajunio     
marzoabrilmayonesa       

 

 

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Hola hombre

    Description
    Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

    Syntax
    EDATE(start_date, months)

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hola hombre

    Description
    Returns the serial number that represents the date that is the indicated number of months before or after a specified date (the start_date). Use EDATE to calculate maturity dates or due dates that fall on the same day of the month as the date of issue.

    Syntax
    EDATE(start_date, months)