Select Page

Convert date to Text for filling CST / VAT form

When filling up CST / VAT form, you need date in text format. Here is the formula to convert the date into text format as required in CST / VAT form.

There are 3 ways you can achive this.

  1. Custom Format
  2. Formual
  3. User Defined Fucntion.

Custom Format

Go to format dialoque box, Go to Number Tab, and enter DD-MM-YY in custom type, as shown in image below.

Excel Custom format for Date

 

Formula

In the above formula, I have assumed the date is in A1 Cell. If your date is in different cell, you can copy the formula to Notepad and replace the A1 with the cell reference where you have date.

Content expected in A1 : 31-03-2015 (Stored as DATE)
Formula generates : 31-03-15 (Stored as TEXT)

Formula assumes that the contents of the column is a DATE and not TEXT. If date is stored as a TEXT, then the above formula will give you answer as “Not a Date”. Moreover, formula works for both the date storage namely DD-MM-YYYY or MM-DD-YYYY

User Defined Fucntion

If you want to use this formula in many places, instead of using the big formula, you can just use simple to use UDF (User Defined Function – AdarshVATDate

Share the post with your Friends / Colleagues if you found it useful.
Don’t forget to subscribe, to receive new posts right to your inbox
Comment below, if you want any more functionality in this formula.

About The Author

CA, ISA, CISA, BCAF. Friends call me Techno Savvy Chartered Accountant. I work at EY in System Audit

2 Comments

  1. Thank you Mr Adarsh Madrecha. As you told us yesterday, you have posted formula for Date to Text. :). All the best

    Reply
  2. Can I just say what an aid to finding somebody who truly is aware of what they’re speaking about on the internet.

    Reply

Leave a reply

Your email address will not be published. Required fields are marked *

Subscribe To my Newsletter

Subscribe To my Newsletter

Join the mailing list to receive the latest news and updates from the blog

You have Successfully Subscribed!

Pin It on Pinterest

Share This