0

I have a spreadsheet with two columns, both with dates in the format dd/mm/yyyy. Is it possible to be able to filter the second column so that the dates in the second column represent one day after the date in the corresponding first column?

Improve this question

1 Answer 1

Reset to default
0

Use a helper column. If the dates are in columns A and B, then in C2 enter:

=B2-A2

and copy downward

Then filter column C to display 1 only:

Before filtering:

enter image description here

and after filtering:

enter image description here

Improve this answer

You must log in to answer this question.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.