I need for a column to put today's date in automatically, however when i open up the same spreadsheet tomorrow i need for yesterdays date to stay and not change.
=if(B1<>"", =today(), "") - what this does is says if cell B1 has text in it, then input today's date in the current cell... otherwise, leave the current cell blank.... This will still put the current date in the current cell every time you open the workbook, however (I think).
Maroon and White Football
Jeff Lebby fires assistants Phil Loadholt and Cliff Odom after Auburn loss
Maroon and White
Mississippi State PFF Grades from 41-9 loss to Auburn
Maroon and White Football
Lopsided analytics illustrate Mississippi State's collapse against Auburn
Maroon and White Football
"Not good enough": Jeff Lebby answers questions of performance and job security following blowout loss to Auburn
Maroon and White Football
Rapid Recap: Auburn 41-9 Mississippi State