Share via

custom date format

Anonymous
2011-09-01T15:09:47+00:00

I want to tweek the Day, date built in format to give me DAY mm/dd/yyyy. I can not figure out how to combine [$-F800]dddd, mmmm dd, yyyy and mm/dd/yyyy. How do I modify the [$-F800]dddd portion to reflect SUN, MON etc?

Thanks!

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Anonymous
2011-09-01T15:24:34+00:00

Hi,

For todays date 1/9/2011 a custom format of

dddd dd/mm/yyyy

returns

Thu 01/09/2100

If you want the full day use

ddddd dd/mm/yyyy

Was this answer helpful?

4 people found this answer helpful.
0 comments

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest