Kindlysinful
New Member
- Joined
- Feb 17, 2007
- Messages
- 29
Hello all,
I have a problem and would appreciate any ideas. I have an excel sheet that in cell C5 the month and day are formatted as, “Aug 27”. In cell D5 the year and time is formatted as, “ 2021 11:23:45 PM”.
I need to combine the month, day and year in the following format, 08/27/2021. What I came up with so far. In cell L2 I have =datevalue(C5), which returns 08/27. In cell M2 I have =LEFT(D5,5) which returns 2021. In cell M4 I have =L2+M2 which returns 3/10/2027.????? Anyone know why the date is off?
Thank you in advance for any assistance
I have a problem and would appreciate any ideas. I have an excel sheet that in cell C5 the month and day are formatted as, “Aug 27”. In cell D5 the year and time is formatted as, “ 2021 11:23:45 PM”.
I need to combine the month, day and year in the following format, 08/27/2021. What I came up with so far. In cell L2 I have =datevalue(C5), which returns 08/27. In cell M2 I have =LEFT(D5,5) which returns 2021. In cell M4 I have =L2+M2 which returns 3/10/2027.????? Anyone know why the date is off?
Thank you in advance for any assistance