=IF(Timesheet!D33>Timesheet!B23+2,"")

[Trevor3007]

Hi

I am trying to cut down the amount of inputting on a time\expenses workbook
.

The cell (d34) is a date and I was hoping to trigger the cell to autofill based on another cell if it was >0, (cell ref Timesheet!D33) , it would look to Timesheet!B23 (which is a date) and as d34 is in the Wednesday column, it would look to Timesheet!B23 and add 2, (ie Timesheet!B23 = 21/1/19, then d34 = 23/1/19.

I tried using:-

=IF(Timesheet!D33>Timesheet!B23+2,"") but it does not work!

I am hoping someone can crack the issue for me?

KR
Trevor3007

 

[Chrisdontm]

If I follow you correctly???, try this in cell D34;

=IF(Timesheet!D33>0,Timesheet!B23+2,"")


If all of this is on the same worksheet then you don't have to have the name of the worksheet in the formula, like this;

=IF(D33>0,B23+2,"")

 

[Trevor3007]

If I follow you correctly???, try this in cell D34;

=IF(Timesheet!D33>0,Timesheet!B23+2,"")


If all of this is on the same worksheet then you don't have to have the name of the worksheet in the formula, like this;

=IF(D33>0,B23+2,"")

morning

Chrisdontm

thanks for that & it works great.

Tally ho & many thanks again.

KR
Trevor3007​