Sorry, all dates in Excel contain a year. You could look at using text,
rather than dates, or protecting the cell. Or tell us more about what you
need to do. There'll be a solution.

Regards,
Fred.

"Mollas" wrote in message
...
Hello,

How do I split the year for dates. The purpose is to prevent viewers from
reformatting the date to find out the year.