Hello All

Very new in VBA so please do excuse if i sound illogical, i am building a excel sheet which has inputs in form of dates in two cell i have used a date picker for that.
After getting the dates in the cells i need to check if the start and the end date should not exceed one year.

In case it does then it should pop a message stating that it has exceeded a year and then wipe out the two dates if they are within a year they should remain as is.

Looking for all the help and thanks in Advance