Ask Your Question
0

Excel has a feature that when you fill in a date, it can automatically give you the day of the week. I am hoping to find this feature in Libre

asked 2018-10-10 00:37:47 +0100

SharonL gravatar image

Excel has a feature that when you fill in a date, it can automatically give you the day of the week. This is nice when looking at ancesters birthdates, as wellas other important dates.

edit retag flag offensive close merge delete

2 Answers

Sort by » oldest newest most voted
-1

answered 2019-04-03 13:52:26 +0100

EasyRider gravatar image

I want to get the day of the week, from a date value in a different column, without a long list of "IF" statements.

edit flag offensive delete link more

Comments

You had been given the answer ~3 years ago ;-)

Anyway - asking a question as an "answer" to another question is incorrect.

Mike Kaganski gravatar imageMike Kaganski ( 2019-04-03 14:35:16 +0100 )edit
2

answered 2018-10-10 01:41:10 +0100

Ratslinger gravatar image

Hello,

This is simply how you format the cell data. Right click the cell, choose Format cells.... In Category choose Date. Then in the Format section select one with you preference of how you want the day displayed - ie: Friday, December 31, 1999.

The N's in the format code determine how & where the day is displayed. NN is abbreviated day and NNN is full day name.

edit flag offensive delete link more

Comments

Same with DDD and DDDD

erAck gravatar imageerAck ( 2019-04-03 22:07:38 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2018-10-10 00:37:47 +0100

Seen: 100 times

Last updated: Apr 03