My target range is "E4:E500" (Heading is date) . I want all the dates to be format dd-mmm (eg :- 5-feb , 14-mar etc ). If i enter only day then add current ongoing month to it (eg:- if 5 is entered then output should be 5-mar). If 5-4-2020 is entered then output should be 5-apr. Also i want to restrict the user . Only 1 to 31 numbers or a date shld be allowed else display warning.
Bookmarks