is it possible for me to enter a month and year in one row and have vba auto calculate the last 12 months back?
example:
October 11
have it show on the row above that the previous month and year?
is it possible for me to enter a month and year in one row and have vba auto calculate the last 12 months back?
example:
October 11
have it show on the row above that the previous month and year?
Hello mdsickler,
This UDF will return the date 1 year back.
Function BackDate1Year(ByVal TestDate As Date) As Date Application.Volatile BackDate1Year = DateSerial(Year(TestDate) - 1, Month(TestDate), Day(TestDate)) End Function
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Star below the post.3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks