HI Need to add 27 a day starting from June 10th this year

[zone709]

Hi I am looking for a formula to automatically add 27 each day that passes starting from zero 0 . Since June 10th this year.
So when i open sheet it would be updated all the time . So right now its probably 38 days since then and number should be around 1026. any help thanks

 

[hagia_sofia]

Would this work:

=27+((TODAY()-DATE(2024,6,10))*27)

 

[dreid1011]

Something like this perhaps:

Book1
	A
1	999
Sheet2

Cell Formulas
Range	Formula
A1	A1	=DAYS(TODAY(),"6/10/24")*27

Excel calculates 37 days at the moment.