Is it possible to use a macro to have excel complete a date dd/mm with the
year depending on the month entered. I.e. if I enter 27/01 it will return
27/01/2018 but if I enter 06/11 it will return 06/11/2017 or If the month
is greater than 6 the year will be yyyy -1. Thanks Bill K

Excel will complete dd/mm entered dates with the current year. If the date
entered belongs to another year then the year must also be entered in the
system default date format.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion