Complete Excel Guide

You will find all the information regarding Excel.

Thursday, 31 August 2017

DATE Function

DATE Function

This function returns the date from user supplied year, month and day.

Syntax:  DATE(year,month,day)

Example: =DATE(2017,8,31)
Result: 31/08/2017

 



Example: =DATE(2010,1,11)
Result: 11/01/2010


Posted by Unknown at 06:11
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: date formula, date function, date() formula, date() function, excel date formula, excel date function, how to use date function in excel

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Unknown
View my complete profile

Blog Archive

  • ▼  2017 (37)
    • ►  September (8)
    • ▼  August (29)
      • NOW & TODAY Functions
      • TIME Function
      • DATE Function
      • Date & Time Functions List
      • TEXT Function
      • SUBSTITUTE Function
      • REPLACE Function
      • MID Function
      • PROPER Function
      • FIXED Function
      • T Function
      • SEARCH Function
      • REPT Function
      • RIGHT Function
      • TRIM Function
      • UPPER Function
      • LOWER Function
      • LEFT Function
      • LEN Function
      • Find Function
      • EXACT Function
      • DOLLAR Function
      • CONCATENATE Function
      • CODE Function
      • CLEAN Function
      • CHAR Function
      • BAHTTEXT Function
      • Text Functions
      • Types of Functions in ExcelText Function  Date ...
Hit Counter
Ethereal theme. Powered by Blogger.