How can I format my dates 12/01/2007 to equal the day of the week?
B Bob Phillips Dec 26, 2007 #2 Use a format of "dddd dd/mm/yyyy" without the quotes -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
Use a format of "dddd dd/mm/yyyy" without the quotes -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy)
K Kevin B Dec 26, 2007 #3 You can enter the date using the following: =TEXT("12/26/2007","dddd") or you can create a custom date format using three d's for an abbreviated weekday or 4 d's for the full weekday name.
You can enter the date using the following: =TEXT("12/26/2007","dddd") or you can create a custom date format using three d's for an abbreviated weekday or 4 d's for the full weekday name.
