Posted on 2011-02-22
Im trying to work out the a date by using the datediff function within a macro Im trying to write.
I have a spreadsheet which has a start date of a agreement, I want to use the datediff function to work out how long the agreement has been live.
This is what I got but its not working.
DateDiff(cell(2, 20), Now(), "yyyy") & "/" & DateDiff(cell(2, 20), Now(), "m")
In the cell (2,20) has a value of 22/02/2010
So when the macro runs it should replace this data with 1yr0mths or 1/0.