How often do we get dates in spreadsheets supplied to us as 12.26.2016, or 26/12/2016 (UK format), only to be told the date is invalid or there's no month 26? This article explores fixing dates with VBA, using TRIM, LEFT, RIGHT and MID functions....
Read more »In this article, there are 4 easy tips for you to change the color of comment balloons or texts in your Word document. By and large, the color of comment balloons in document is randomly assigned by Word according to the editing author....
Read more »In this article, we want to present you 2 quick and efficient ways to get the difference between 2 specific dates or times via Word macros. To calculate the days or time left between 2 concrete dates or times is of no difficulty. You can either...
Read more »