I need to create a formula field that will show a date along with the day of the week, to be used in an email template.
For example: Wednesday, 29 September 2021
Help is much appreciated!
6 answers
Hi,
CASE( MOD( date - DATE( 1900, 1, 7 ), 7 ), 0, "Sunday", 1, "Monday", 2, "Tuesday", 3, "Wednesday", 4, "Thursday", 5, "Friday", "Saturday" )
+ "," +
TEXT(DAY( Date ))
+ " " +
CASE( MONTH( date ), 1, "January", 2, "February", 3, "March", 4, "April", 5, "May", 6, "June", 7, "July", 8, "August", 9, "September", 10, "October", 11, "November", "December" )
+ " " +
TEXT(YEAR( Date ))
