|
|
#4
07-21-2018, 11:39 PM
|
||||
|
||||
You could also use:
strdate = Split(strdate, "-")(0) I'd also have thought it fairly obvious that you could change: MatchCase:=True to: MatchCase:=False
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| if cell contains date, then month, else blank | Merlot | Excel | 7 | 03-20-2025 08:16 AM |
 Auto update excel graph range, ignore data when date reads 00-Month-00
|
SavGDK | Excel | 2 | 06-24-2016 08:05 AM |
| Excel day date month year Function | greginky | Excel | 1 | 01-05-2016 02:19 AM |
|
Filter by a Month that falls within a date range
|
MattG1225 | Excel | 2 | 12-03-2015 07:44 AM |
| Formula to subtract one month from due date field in reminder field | ghumdinger | Outlook | 1 | 10-01-2011 12:09 AM |
Windows 7 64bit 
Office 2010 32bit
Threaded Mode