In this tutorial we are going to write a formula that allows us to increase the dates in a column by one every time a block of unique values repeats.
In this tutorial we are going to look at two ways to convert dates that are formatted in odd ways, for example using commas or periods to separate the month, day, and year, to a format that uses the forward slash, which is more traditionally used in Excel.
In this tutorial we are going to use the MAX and IF functions in an array formula, along with INDEX and MATCH to extract the last date in a list of events that is less than a control date and the event related to that date.
In this tutorial we are going to look at the undocumented function in Excel DATEDIF. This could be a great tool to dynamically calculate the number of years, months and days between two dates.