Excel formula to automaticaly insert date if column c is filled

[sunboy]

Hi

I am kindly asking for an excel formula to automatically write "1 Jan 21" on column A, if there is a name on column C. If there is no name in column C, date should not appear. Please see the attached excel sheet.

Regards,

Sunboy

[bebo021999]

Try:

=IF(C6="","",DATE(2021,1,1))

[sunboy]

Hi Bebo021999

Thank you. The formula works well.

Regards,

Sunboy