I created a spreadsheet with 5 columns, the top of each column is the TODAY() function. The items below the date are deliveries (text) to happn on that date. The problem is that when the date changes, the columns shift to the left but the text in the column stays, so the delivery data for January 31 is now on February 1
How can I make the text follow the date?
explained in first field
I created a spreadsheet with 5 columns, the top of each column is the TODAY() function. The items below the date are deliveries (text) to happn on that date. The problem is that when the date changes, the columns shift to the left but the text in the column stays, so the delivery data for January 31 is now on February 1
How can I make the text follow the date?
explained in first field
Share Improve this question asked Feb 2 at 21:18 FredFred 11 bronze badge 1- Please provide enough code so others can better understand or reproduce the problem. – Community Bot Commented Feb 5 at 13:44
1 Answer
Reset to default 1You can't. By definition, formulas get re-calculated. The Today() function specifcally is volatile and will update each time any cell on in the workbook changes. If you want to keep the date together with the data it belongs to, consider using a different approach, like typing the date into the cell.
The keyboard shortcut Ctl+; (Control + semicolon) will enter the current date as a constant in one go. Using that will be quicker than typing =Today() into the cell and it will not change tomorrow.
发布者：admin，转转请注明出处：http://www.yc00.com/questions/1745256024a4618962.html
评论列表（0条）