Print custom date for data validation

[TheFuzzball]

I need a function that can be used to print a specific day, a specific month but a dynamic year. e.g. 01/08/YEAR



I need this to change on its own so that I don't have to change it myself.

[dcrake]

Can you provide an example on how you intend to use this functionality and the reasoning behind it.

David

[SoftwareMatters]

If you just want to display it on a form or report etc use something like this:

Public Function DatePlusYear() As String
DatePlusYear = "01/08/" & Year(date)
End Function