Forum Discussion

gwak's avatar
gwak
New Member
9 years ago
Solved

Convert month text into date

Hi everyone,

 

I'm trying to convert my months that are in text into date months.

 

Everytime I try, it puts the message error.

 

Any help ? 

 

Thanks.

 

  • Anonymous's avatar
    Anonymous
    9 years ago

    put together a lovely (full) text of the date, then use datevalue( ).

     

    =DATEVALUE([Year] + "/" + [Month] + "/" + 01)   or similiar.

1 Reply

  • Anonymous's avatar
    Anonymous
    Not applicable

    put together a lovely (full) text of the date, then use datevalue( ).

     

    =DATEVALUE([Year] + "/" + [Month] + "/" + 01)   or similiar.