View original (French)

Formula for the 15th of the following month

Solved
Puce -  
 Puce -
Hello,

I have a table and I need to include a formula that will give the date of the 15th of the following month.

Example: In one cell, I have the month October (text), and in another cell, there should be a formula that indicates the 15th of the following month. The formula must be automatic when I change the month in the cell where it says October.

Configuration: Windows / Chrome 42.0.2311.135

3 answers

  1.
    DjiDji59430 Posted messages 4278 Registration date   Status Member Last intervention   717
     
    Hello,

    if October is in A3, we can put

    =DATE(2015;MONTH(DATEVALUE(15 & "-" & A3 & "-" & 2015))+1;15)

    Regards
    0
    1. Puce
       
      A big thank you!!! You are saving my life.

      Long live the forum :-)
      0
  2. Gyrus Posted messages 3360 Status Member 526
     
    Hello,

    Or alternatively, with the month in A1:
    =DATEVALUE(15 & A1)

    See you!
    0
    1. Puce
       
      A big thank you to you too!

      I'm taking note of everything because there's so much to do with Excel.

      See you later!
      0
  3. michel_m Posted messages 18903 Registration date   Status Contributor Last intervention   3 320
     
    Hello

    to complete Gyrus's formula, which I salute
    for the 15th of the following month
    =EDATE(DATEVALUE(15 & A1),1)
    to be formatted as date-number
    --
    Michel
    0
    1. Puce
       
      Thank you very much to you too!!

      I note all the possibilities, as they will be useful to me for the future.

      See you later!
      0