If a cell contains a "1" I want to copy a date from another cell into an adjoiining cell which will be hidden and used for another formula.

Hi,

I am having difficulty setting up what should be a simple formula. I think the issue is that I am trying to copy a date as I believe that IF does not recognize dates

What I am trying to do is:  If F9 = “1”, I want to copy a date from A9 into E9 so I can then count how many time that each month appears in E9 for a yearly report. I have this formula already. F9 will either be empty or will be a 1 which is calculated using a formula.

I can add an additional coulum to copy the date and wrap it in a date value function  and then hide that column if necessary. It would be a bit messy but I just want something to work.

I have also tried
=IF(ISNUMBER(SEARCH

Any help would be greatly appreciated.

Thanks
Dot