Hi,

The first should be correct. Are you certain C4 is a date number?

Upload the workbook so that we can take a look

Regards