If date in in general format then it is required to change its format to date format. i.e. dd-mmm-yyyy. If date is blank in any cell then i want to copy the date of the previous block and then paste it in blak cell

How to get this? Please help
fashion zone2.xlsx (31.2 KB)

Hi @aparna3010 !
Would you mind giving us more information ?

  • what is/are the column(s) that you want to work on
  • what does what is the block that you speak about ?
  • would you mind sending us a screenshot of before and after so we understand ?