ExcelBanter - Date and day

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Date and day (https://www.excelbanter.com/excel-programming/322578-date-day.html)

Alvin Hansen[_2_]

Date and day

Hi!!
Can i if i have the date of a day
Get det day name ?

Best ragards alvin

JE McGimpsey

Date and day

Format your cell with Format/Cells/Number/Custom dddd

In article ,
Alvin Hansen wrote:

Can i if i have the date of a day
Get det day name ?

Tom Ogilvy

Date and day

format(Date,"dddd")

demo's from the immediate window:

? format(date,"dddd")
Monday

--
Regards,
Tom Ogilvy

"Alvin Hansen" wrote in message
...
Hi!!
Can i if i have the date of a day
Get det day name ?

Best ragards alvin

All times are GMT +1. The time now is 05:26 PM.