Month to Date Format

Spoiler
I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?
Tagged:

Best Answer

  • Misbah
    Answer ✓

    @ansn 

     

    Write END(Date) as formula. If there is a time as a dimension then just END() would do

     

    Misbah

Answers