When I copy a cell that is formatted for Date has date it will copy that date. If blank instead of 0 it gives 1/0/1900.

Is there any formula that will give me 0 when to be copied cell is blank and if there is value copies the value.

Last edited: 29-Jul-21 03:56 PM