alliswell
Board Regular
- Joined
- Mar 16, 2020
- Messages
- 190
- Office Version
- 2007
- Platform
- Windows
- Mobile
Good morning everybody !
In a1 i have 04052023 in b1 i put formula this way =date(right(a1,4),mid(a1,3,2),left(a1,2))&" "&text(a1,"dddd") to get this result 04/05/2023 thursday but it didnt work. Instead i get results ##########################
In a1 i have 04052023 in b1 i put formula this way =date(right(a1,4),mid(a1,3,2),left(a1,2))&" "&text(a1,"dddd") to get this result 04/05/2023 thursday but it didnt work. Instead i get results ##########################