Macro that converts today()+3 in to text on 2 columns

The code looks fine - is it throwing up any errors? Have you tried putting a debug in and stepping through it (perhaps with smaller ranges).

It's throwing no errors up unfortunately. The weird thing what's happening, is that only DateRng2 is working, it appears to ignore the first for loop which I require for the L column..but then moves onto the second for loop and works fine!

Does the ranges ("B5:B36665") and ("L5:L36665") contains date?

Not all of them. If a user fills out A1, then B1 is filled with a today(). If a user fills out K1, then L1 is filled in with today()+3, so that macros intention is to convert the formula into text so the date is static. It does this correctly, how ever it's ignoring the first for loop.

After you've set DateRng just stick in a line:

Please Login or Register  to view this content.

And make sure it has the correct range in there (although I can't see any reason why it shouldn't)

If that's OK change the line to:

Please Login or Register  to view this content.

Which should return 36,661.

Out of interest, you've said that not all of the cells contain a date - what's in the cells that don't contain one? Is there any reason you couldn't just use a PasteSpecial for the whole range at once, it would be much, much faster than looping through every cell.