Validating dates in excel

[Update]: Since posting this article on selecting multiple items from an Excel drop down list, I’ve added more articles on this topic.

Here are a few links to updates: In the sample file, there are different examples of the code, with options for where the selected items are placed.

If you do not need that code, you can remove it from the This Workbook module.

validating dates in excel-14

The kit has 3 sample files, and a user guide, with details and screen shots, on how to add this technique to your own workbooks.

Click here for details: Data Validation Multi Select Premium.

Income Tax efiling can also be done without downloading the Income Tax Software and simply by furnishing all the details online.

For efiling Income Tax Return without downloading the Java Utility, a person would be required to login to his account on https:// and then go to If the Income Tax Returns have not been Digitally Signed, the taxpayer would be required to take a print out of the ITR-V Acknowledgement Form, sign it and send it to the Income Tax Department Recommended Read: Manner of sending ITR-V to Income Tax Department The Address for sending duly signed ITR-V form is “, it will be deemed that the return in respect of which the Form ITR-V has been filed was never furnished and it shall be incumbent on the Tax Payer to electronically re-transmit the data and follow it up by submitting the new Form ITR-V within 120 days.

In your workbook, you could change the 3 to a different number.

Or, if you don’t want to limit the code to a specific column, you could delete the two rows that are marked with a red circle.

This completes the income tax efiling process for non-digitally signed Returns.

You’ve probably used an Excel data validation drop down list, where you can click the arrow, and select an item to fill the cell.

You might want all the items in a single cell, or in adjacent rows or columns.

For example, each item selected in this drop down list fills the next empty cell at the right.

The Income Tax Department releases an updated income tax software for free every year for income tax efiling online.

Tags: , ,