Use of EOMONTH

it is used to calculate end of month

=EOMONTH(Select DATE,0)

 

Example

Use of EOMONTH Command in Data Validation - Data Validation

 

 

 

USE OF TODAY FUNCTION IN EXCEL

It is used to get current date in excel

Formula is

=TODAY()

Example:-

Suppose Today is 14 Sep 2016,this command =TODAY() will show 14/09/2016

Next day,same formula will show 15/09/2016

 

 

Q4A

A person should just enter date of sales

It should automatically show due date of tax

which is 21st of next month

DATA VALIDATION q4.png

 

Download and try 


 Q4B

A person should just enter month of sales

It should automatically show due date of tax

which is 21st of next month of sales

 

 

DATA VALIDATION q4b.png

 

 


Q5

Due date of oayment of tax is 21st of next month

Interest on Late payment of Tax is 15%

Prepate Late payment interest calculator in which user only has to put white values

DATA VALIDATION q5 new.png

 

 

 

 

  1. Accounts Tax
  2. Excel
Ask Download

About the Author

CA Maninder Singh's photo - Expert in Practical Accounts, Taxation and Efiling
CA Maninder Singh
CA Maninder Singh is a Chartered Accountant for the past 8 years. He provides courses for Practical Accounts, Taxation and Efiling at teachoo.com .
Jail