Topic starter
Is there a way to get Excel 365 to do a date that starts or ends with the day in both number and word form?
If there is for the life of me I cant find out how to do it !
Edit: I can see you can do it using the text formula, but its for a simple project plan so I dont want to have to have 2 columns with dates in.
Thanks
Posted : 24/01/2022 3:49 pm
ddd,dd mmm
Stick that in the custom box.
Posted : 24/01/2022 3:51 pm
Topic starter
Thanks dissonance, that has worked ! I have been trying similar for the last 20 mins and not got it to work, must have been the order I tried
Posted : 24/01/2022 3:53 pm