Forum Discussion

ColinCowan's avatar
ColinCowan
Helper I
3 years ago
Solved

Replace Numbers with Date Sequencial

Hi, hoping someone can help my aim is to replace the numbers with the specified date after each date change.  
Need Help
  • ColinCowan's avatar
    ColinCowan
    3 years ago

    Hi, thanks that works and easier much appreciated.

     

    Regards Colin

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    3 years ago

    Hi ColinCowan ,

    My pleasure!

    If it works, would you mind accept it as solution? Then more people who have the same requirment will find the solution quickly and benefit here, thank you!

     

    Best Regards,
    Community Support Team _ kalyj

ColinCowan's avatar
ColinCowan
Helper I
3 years ago

Greg

 

Thanks Can I reset as I am now confussed should the formula be

 

 

v-yanjiang-msft's avatar
v-yanjiang-msft
Community Support
3 years ago

Hi ColinCowan ,

Another way maybe easy to understand for you.

1.Select the column then click Data Type option.

2.Select Date/Time.

3.Then you will find the numbers return error, right-click the column and select Replace Errors.

4.Enter null in the dialog.

5.Select the column, then click Fill Down.

Result:

I attach my sample below for your reference.

 

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

 

  • ColinCowan's avatar
    ColinCowan
    Helper I
    3 years ago

    Hi, thanks that works and easier much appreciated.

     

    Regards Colin

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    3 years ago

    Hi ColinCowan ,

    My pleasure!

    If it works, would you mind accept it as solution? Then more people who have the same requirment will find the solution quickly and benefit here, thank you!

     

    Best Regards,
    Community Support Team _ kalyj