Recalls sound expensive.
It is not difficult to do, but how do you intend to input the information and get the output.
Sorry, you need code, so you need to create a module with this code:-
-
Option Compare Database
-
Option Explicit
-
-
Function LastDayOfMonth(StartDate As Date, MonthsAway As Integer) As Date
-
'Print LastDayOfMonth(#1/2/17#, 2) January second
-
'Print LastDayOfMonth(#2 jan 2017#, 2) January second
-
'###### NOTE DATE MUST BE ENTERED AS #mm/dd/yyyy# or #dd mmm yyyy#
-
-
Dim NewDate As Date
-
-
NewDate = DateAdd("m", MonthsAway, StartDate)
-
-
LastDayOfMonth = DateSerial(Year(NewDate), Month(NewDate) + 1, 0)
-
-
End Function
-
Note the remarks that the start date must me in American format or with the month spelt out.
Phil
