Formula for Day of the Week Based on Date

Hi all,

I am wondering if there is a way to create a formula that automatically fills a field with the day of the week (Monday, Tuesday etc) based on date field in the same entity.

For example, I have a manual drop down with the day of the week (see below) but I’m hoping to automate it. I’m a bit of a novice user and not very well-versed with formulas so I thought I’d check with the experts :slight_smile:

Date

Thanks very much!

You can use ‘WeekDayName’ for that :slight_smile:

WeekDayName([Closing date]) will give you the correct output!

2 Likes