I need a macro that searches column B for any cells with a date format (any date format). If true, I need cells (B:F) (in the same row), to be cut and pasted to the row above in columns (D:H). Then I need that original row to be deleted.

I have found a few macros and functions that are similare but none that work for what I need.

I would greatly appreciate any help anyone can give!