Offset

[elemexcel]

Hello

I need help with the OFFSET formula please.

I have a list of dates - for ease lets use the following -

01/10/2018
01/11/2018
03/12/2018
02/01/2019

I am attempting to have a list, whereby if I change the list to say 01/11/2018, another cell will change to the next date, if it >TODAY()

For example - if I change the list to 01/10/2018, the other cell value would change to 01/11/2018 as today's date is greater than the previous date (01/10/2018) but if I change the list to 01/11/2018 then it would remain static at 01/11/2018 and not jump to 03/12/2018.

I have the following -

[TABLE="width: 83"]
<colgroup><col></colgroup><tbody>[TR]
[TD]=IF(BG35>TODAY(),OFFSET(CA4,-1,0,1,0))

However it is clearly wrong and probably not detailed enough therefore any help would be very much appreciated as this is the first time with the OFFSET function.

Many, many thanks! [/TD]
[/TR]
</tbody>[/TABLE]

 

[nemmi69]

So I set the value below "Start" as the date to change. Today starts at A2

[TABLE="width: 304"]
<colgroup><col span="2"><col span="2"></colgroup><tbody>[TR]
[TD]Today[/TD]
[TD]Start[/TD]
[TD]+ 1 days[/TD]
[TD]+ 2 days[/TD]
[/TR]
[TR]
[TD="align: right"]303/10/2018 [/TD]
[TD="align: right"]09/10/2018 [/TD]
[TD="align: right"]10/10/2018[/TD]
[TD="align: right"] 11/10/2018[/TD]
[/TR]
</tbody>[/TABLE]

the formula for +1 days (C3) =IF($B$3>$A$3,$B$3+1,"N/A"), for +2 days (C4) =IF($B$3>$A$3,$B$3+2,"N/A"). Theses cells need to be formatted as dates.

Hope this helps