How do I determine the 14th month prior to a given date?

[TB]

I have a spreadsheet with dates in the format mmm-yy. I need to determine (calculate) the month that occurs 14 months prior to this date (I only need the month and year, not a specific date). Then I will need this 'early' date in the same format, mmm-yy, to be used later in the VBA program.

Let's say "Aug-05" is in cell A1. Excel will calculate (in cell B1, for example) the 'early' date using the formula: A2 - 30*14. But this formula will not work in VB.

Any suggestions?

 

[sweater_vests_rock]

TB.

Would this do what you want?

Sub TestDate()

Dim MyDate As Date

Range("A1").Value = "Aug-05"

If IsDate(Range("A1").Value) Then
    MyDate = Range("A1").Value - 30 * 14
    MsgBox MyDate
End If

End Sub

hope this helps. ben.

 

[TB]

Thanks, Ben.

You got me moving in the right direction. I made a few modifications for my purposes but you provided exactly the direction I needed!