Generating date from day, month year
Col A Col B
1 =DATEVALUE(A1&"-"&A2&"-"&A3)
September =TEXT(B1,"mmmm")
2009
If this post helps click Yes
---------------
Jacob Skaria
"Ned Harrison" wrote:
Hello all,
Is there any way I can generate a date in one cell, from 3 other separate
cells - one each for day, month, year? i.e. if you enter (for example) '01'
in A1, 'September' in A2 and '2009' in A3, then in B1 it shows '01/09/2009'.
Alternatively, is there a way I can generate the month from the date - so if
you enter (for example) '01/09/2009' in A1, it shows 'September' in B1?
Many thanks in advance for your help,
N
|