Date update using formulae (non-VBA code) for Android

[skarnik01]

Hello,

I need a simple solution to update data, which is retrieved as per date entered in one cell

1. Say - date in cell A1 is updated to 1-Nov-20
2. It retrieves data for fields - A,B,C,D (do-able as per available lookup Excel formula)
3. I need to update these fields - A,B,C,D and store it back into DB
4. When I change A1 to 2-Nov-20, it retrieves A,B,C,D for 2-Nov and is available for update

Though it is very easy through VBA, I intend to use it through Android...and thereby need a way out

Thanks in advance

 

[herofox]

please Upload excel file

 

[skarnik01]

Hello,

Sorry for delayed response. Please note the attached file

 

[herofox]

if you mean this date in cell D1 ,,, You can to Use this

=TODAY()