Thread
:
Automatically update user-inputted date after specified time range
View Single Post
12-03-2019, 09:49 AM
NoSparks
Windows 7 64bit
Office 2010 64bit
Excel Hobbyist
Join Date: Nov 2013
Location: British Columbia, Canada
Posts: 831
Try changing
Code:
cel = DateAdd("yyyy", 1, cel)
to
Code:
cel = DateSerial(Year(Date), Month(cel.Value), Day(cel.Value))
NoSparks
View Public Profile
Find all posts by NoSparks