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

 

 

 

 

Get live Maths 1-on-1 Classs - Class 6 to 12

Ask a doubt
CA Maninder Singh's photo - Co-founder, Teachoo

Made by

CA Maninder Singh

CA Maninder Singh is a Chartered Accountant for the past 13 years. He also provides Accounts Tax GST Training in Delhi, Kerala and online.