Date Formula For Master Sheet

BESP10

Good afternoon,

Per attached how would I set a formula up for the date in "Needed On Site" column to equal the date in the "End Date" delivery column

Thanks

Date Formula.pdf

Paul Newcome

Have you tried...

=[End Date]@row

?

BESP10

Hi @Paul Newcome

Yes I did , thank you .

What we are doing is creating a report for our shop manager so he knows the date that the product needs to leave our facility. The =[End Date]@row is returning for that specific row. We need to be able to return the date for when the product is shipping which is the row below so that we can show it in a report without him having to visit the master sheet

Date Formula 2.pdf

Paul Newcome

Oh. Then you should be able to change "@row" to the corresponding row number.

BESP10

Would I have to do it for each instance or can this be a column formula? @Paul Newcome

and thank you

Paul Newcome

It would have to be for each instance.