0

In a sheet which has tab names as date ., can I empirically refer previous sheet, so I can calculate report based on yesterdays?

=IMPORTRANGE("Link",""&BM4&"!AU:BC")

where BM4 is a date, but it is taking its absolute value instead of date as . Sheet name is date.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.