You realize that when you use Now you are putting both a date and a time value in each cell.
It looks from your formatting that you only want the date information in cells C1 and A51.
In which case use Date not Now
Now will work, but you may get unexpected results later
If you run this:
Range("A1").Value = Now
Range("A1").NumberFormat = "mm/dd/yyyy"
Then edit the same code to this:
Range("B1").Value = Now
Range("B1").NumberFormat = "mm/dd/yyyy"and run it.
(Don't try this with all 4 lines in one subroutine - you need to run it twice - once for col. A and once for col. B)
In the worksheet, cells A1 and B1 will both show today's date - they will appear identical.
In another cell enter this formula:
The result is 'Not equal'
If you do the same with Date instead of Now, the result will be 'Equal'