Skip to main content

Hi, I'm wanted to show date format in ddd, d-mmm-yy format (yellow highlighted) but in the formula date_range calc field, but getting an error in my calculated field as below where:

Date Format Qs

 

pastedImage_3.png

Any tips on how to fix this? Workbook attached.

2 answers
  1. Dec 12, 2019, 1:00 AM

    Hi Puja,

     

    You should omit/move some character.

    Hi Puja, You should omit/move some character.

     

    <fixed formula (a part)>

    pastedImage_1.png

     

    <result>

    pastedImage_2.png

0/9000