Hi,
In my spreadsheet I have a sheet called "Stats" with various tables on it, on of which is a list of dates (header is in W1, values are in W2:W14). The dates are calculated by the first date being entered manually by me (just made the list so the first date is today) and the remainder being +14 of the date in the cell above.
What I want is a formula that can work out when the next date in the list is...so, for example, now it would show 18th July as that is the next date. The only way I can think of is doing a string of IF's, but there must be a simpler way of doing it without checking every value in the list?
Any ideas?
In my spreadsheet I have a sheet called "Stats" with various tables on it, on of which is a list of dates (header is in W1, values are in W2:W14). The dates are calculated by the first date being entered manually by me (just made the list so the first date is today) and the remainder being +14 of the date in the cell above.
What I want is a formula that can work out when the next date in the list is...so, for example, now it would show 18th July as that is the next date. The only way I can think of is doing a string of IF's, but there must be a simpler way of doing it without checking every value in the list?
Any ideas?