JohnHinkle ✭✭✭✭✭✭

• Activity
• Discussions3
• Comments234

• Re: Show date as day of the week

  JohnHinkle

  04/29/16
  Try this: =IF(WEEKDAY([Start Date]6) = 1, "Sunday", IF(WEEKDAY([Start Date]6) = 2, "Monday", IF(WEEKDAY([Start Date]6) = 3, "Tuesday", IF(WEEKDAY([Start Date]6) = 4, &qu…
  2 ·

• Re: Convert date format to mmm-yy

  JohnHinkle

  02/22/16
  You could also use this which would require only one column (using LEFT, rather than MID): =IF(MONTH([Start Date]1) = 1, "Jan-" + RIGHT(YEAR([Start Date]1), 2), IF(MONTH([Start Date]1) = 2,…
  1 ·