Apologies for the poor subject but I'm not too sure what it is I'm asking for.
In my spreadsheet there is a column B which contains dates. I want to be able to report on all the cells within a range based on a user entered date.
For example if the user says 20th of Feb then the range is all of the rows with today's date in column B down to all of the rows with the 20th of Feb in column B.
How do I take the dates and use them to define a range that I would like Excel to work with?
In my spreadsheet there is a column B which contains dates. I want to be able to report on all the cells within a range based on a user entered date.
For example if the user says 20th of Feb then the range is all of the rows with today's date in column B down to all of the rows with the 20th of Feb in column B.
How do I take the dates and use them to define a range that I would like Excel to work with?