Excel Date Issue (Unrecognizable via formula)

[Hyflex]

Hey,

I'm having an issue where a formula wont recognise a date in a cell input via macro, how can I fix this?

Please Login or Register  to view this content.

Cell B2: =IF(ISNUMBER(A2),A2,B1)
Cell B3: =IF(ISNUMBER(A3),A3,B2)

If I click on the macro inputted "A2" and click in the formula bar and press enter it works fine. but I don't want to have to clic.

Added an example

Please help
- Hy

[watersev]

hi Hyflex, try this:

Please Login or Register  to view this content.

[Hyflex]

Hey watersev,

Thank you ever so much, that works perfectly. I had edited my original post to include an example lol :P

Thanks, rep added.

Regards
- Hy