To do this, we are going to use the following nested IF formula with circular references in the second IF function: column, and C2 is the cell where you input the formula and where the time stamp will eventually appear.
In the above formula, the first IF function checks cell B2 for the word "Yes" (or any other text you supply to the formula), and if the specified text is there, it runs the second IF function, otherwise returns an empty string.
Or, perhaps you want to insert a date in Excel that will update automatically and always display the current date and time?
Or, maybe you want to auto fill weekdays or input random dates in your worksheet?
If a date you've entered displays as a number of pound signs (#####) in a cell, most likely the cell is not wide enough to fit the entire date.
To fix this, double-click the right border of the column to auto fit the date, or drag the right border to set the desired column width.
You can type a date in an Excel cell in a variety of ways, for example 1/1/2015, or 1-Jan-2015, or 1-Jan, or January 1, 2015.
To prevent having the date change each time a worksheet using automatic recalculation is opened, try using this keyboard shortcut to enter the current date instead.If this does not help, please check other Excel date format troubleshooting tips.In Microsoft Excel, you can input the current date and time either as a static or dynamic value. Timestamping is entering a "static date" that won't change with the course of time or when the spreadsheet is recalculated.Luckily, Able Bits Random Generator for Excel does :) You simply select a range of cells where you want to autofill dates in a random order, and switch to the Random Generator's pane where you specify: button, and have the selected range populated with random dates.Apart from dates, the Random Generator add-in can auto fill your worksheets with numbers, Boolean vales and custom lists.