MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Macro that uses DATEDIF

Posted by Ben on December 22, 2000 2:03 PM

How do I create a macro that puts the formula and puts the date it was run in the formula as follows "=DATEDIF(Date macro was run,TODAY(),"M")" into a cell.

Posted by cpod on December 22, 2000 4:18 PM

Try this:
Worksheets("Sheet1").Range("A1").Formula = "=DATEDIF(""" & Date & """,today(),""M"")"

Posted by Ben on December 23, 2000 3:04 AM