Forum Discussion
gwak
9 years agoNew Member
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.
- Anonymous9 years ago
put together a lovely (full) text of the date, then use datevalue( ).
=DATEVALUE([Year] + "/" + [Month] + "/" + 01) or similiar.
1 Reply
- AnonymousNot applicable
put together a lovely (full) text of the date, then use datevalue( ).
=DATEVALUE([Year] + "/" + [Month] + "/" + 01) or similiar.