Formatting DATEADD in IF statement


#1

I’m wondering how I would add the DATETIME_FORMAT (if that’s correct) formula into the current formula so that the output is MM/DD/YYYY instead of the format shown within the red circle.

‘Linesheet’ is a DATEADD formula, if that matters.


#2

You would surround DATEADD(...) with DATETIME_FORMAT(...) so that its output is what gets formatted.

IF(
   {New Color}="Y",
   DATETIME_FORMAT(
      DATEADD(
         Linesheet,
         5,
         'week'
      ),
      'l'
   ),
   "Done"
)

#3

Thanks! It worked. Much appreciated.