I was going to ask how I could change a Date column to display a two-digit year? So "8/8/22" instead of "8/8/2022" I am saving horizontal screen space & getting more for less by ending up displaying my Meeting Date as "08/08/22 = Tue"
But then I used my brain for a second & thought about the excellent help/ TEXT formula I just got from @Suvrutt_Gurjar to display the proper day from a date using TEXT([Date],"DDD") to give Mon, Tue, Wed... and also TEXT([Date],"DDDD") to give Monday, Tuesday... It was easy to imagine exactly what I needed to display my short two digit year with, you guessed it... TEXT([Date],"MM/DD/YY") It worked! Thanks again Mr. Suv!
LinkedIn
Twitter
