AccessShell
Board Regular
- Joined
- Sep 5, 2015
- Messages
- 50
- Office Version
- 2003 or older
- Platform
- Windows
I am trying to get ddd from mm/dd/yyyy in a formula, not in an Excel macro. ddd represents the first three characters of the day of the week.
The date mm/dd/yyyy is in col B. I want ddd in col A. I know in VBA, I can write format(MyDate, "ddd").
I tried, in C2 the formula =Format(B2,"ddd"). That doesn't seem to work.
Thanks
The date mm/dd/yyyy is in col B. I want ddd in col A. I know in VBA, I can write format(MyDate, "ddd").
I tried, in C2 the formula =Format(B2,"ddd"). That doesn't seem to work.
Thanks