validating formulas in excel 2016 - Dating waqas

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?

dating waqas-9

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.

If you are using a 32-bit version of Excel, you can use Microsoft's Date Picker control.

For the detailed instructions, please see How to insert calendar in Excel (Date Picker control).

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.

When you type something like that in a cell, Microsoft Excel knows you are entering a date and automatically applies the date format to that cell.

If you are using a 64-bit version of Excel 2016, Excel 2013, Microsoft's Date Picker control won't do.

In this case, consider using one of the third-party calendars, for example our own one :) For more options, please see third-party drop-down calendars for Excel. I am hopeful these date entering techniques, shortcuts, functions and Excel auto date features have proved useful to you.

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.

Tags: , ,