Automatic Static Date issues

[UnderTheArmour]

Hi all. I only use phone or tablet based versions of Excel and so am having a problem with automatic static date entry..

When I add new inventory I want the date entered but to stay static, which normally isn't a big problem, butt there's no drop-down menu to figure Iterative through and I can't seem to find an online site to edit my file in when I use search and then toggle to Desktop Site which was my first attempt to solve the problem...

Any ideas short of just sending my fine too someone and getting them to do it from a proper computer and just send it back?

Here's the formula I'm using...

=IF(A23<>"",IF(R23<>"",R23, today()),"")

 

[cmowla]

To make dates static without VBA (you can't run VBA on the mobile version of Excel, so this applies to you):

Option 1
Manually convert the dates to static values.

1. Select all of the date cells with today's date.
2. Copy them.
3. Go to paste special and select this option/icon.
   
   

But with this option, you will lose =TODAY() in the formula (of course you will!), so just be sure to copy down the date formula down 1 extra row for the next day, and only make the dates cells that are above it static.

Option 2
Choose any (random) static date, put it into a cell of your choice, create a helper column (extra column for calculations that are not for your data itself, but just for "static date" support) and manually input an integer in the column such that the date matches today's date when you are adding new inventory.

Example:

Book1.xlsx
	A	B	C
1		10/1/2022
2		1	10/2/2022
3		1	10/2/2022
4		1	10/2/2022
5		1	10/2/2022
6		1	10/2/2022
7		1	10/2/2022
8		1	10/2/2022
9		1	10/2/2022
10		2	10/3/2022
11		2	10/3/2022
12		2	10/3/2022
13		2	10/3/2022
14		2	10/3/2022
15		2	10/3/2022
16		3	10/4/2022
17		3	10/4/2022
18		3	10/4/2022
19		3	10/4/2022
20		3	10/4/2022
Sheet8

Cell Formulas
Range	Formula
B1	B1	=DATE(2022,10,1)
C2:C20	C2	=$B$1+B2

Option 3
(What the next persion will suggest.)