Convert date to a custom format

Hi Team,

I cant work out a formula which would let me transform a standard date to the format i need, 2 examples are given below

07/12/2020 to 07122020:000000
08/12/2020 to 08122020:000000

Could anyone help?

thanks
Gary

If you really mean a Custom Format (i.e. applied to the cells containing the dates), then you can use this format string in the Custom Format dialogue box:

ddmmyyyy":000000"

Hope this helps.

Pete

Perfect, thanks Pete

You're welcome - thanks for the rep.

Pete