Commonly Used functions
- Now- It is used to give the current date and current time.
Formula: “ =NOW() “
![](https://tutorialslink.com/Article_img/Blog_image/44822a88-20aa-4010-8b9e-2e7221e882bc.jpg)
- Today – It gives the current date.
Formula: “ =TODAY()”
![](https://tutorialslink.com/Article_img/Blog_image/3448289d-f50d-4b7f-8bfb-f1a23885eb8a.jpg)
- Date – It takes three arguments namely “year” , “month” , “day”
Formula: “ =DATE(G2,H2,I2)”
![](https://tutorialslink.com/Article_img/Blog_image/e1b7988b-796d-47af-84bb-124824e14653.jpg)
- For extracting year, month, day from a given date we have predefined functions provided by excel.
- YEAR
It takes one argument as shown below.
OUTPUT
![](https://tutorialslink.com/Article_img/Blog_image/f4984eb1-62fc-4fa1-924e-0c26d2c5caff.jpg)
![](https://tutorialslink.com/Article_img/Blog_image/e5ac02f6-7b84-4af4-ab74-17ff0bed8e74.jpg)
- MONTH
It takes one argument as shown below
OUTPUT
![](https://tutorialslink.com/Article_img/Blog_image/cfdd4968-f2f3-403f-8079-b6aaf29457d9.jpg)
![](https://tutorialslink.com/Article_img/Blog_image/ba246c1c-aa5b-4db9-9cb4-84db26ae21fb.jpg)
- DAY
OUTPUT
![](https://tutorialslink.com/Article_img/Blog_image/71291551-3409-418c-92ef-8199877d22d6.jpg)
![](https://tutorialslink.com/Article_img/Blog_image/8efc79fc-2d2e-4f82-89b5-51ba9c0263d5.jpg)
- TIME- It takes three arguments namely hour, minute, second.
It is used to get time if above mentioned parameters are given.
OUTPUT
![](https://tutorialslink.com/Article_img/Blog_image/f545111b-2f77-4207-a677-1537cd96efb1.jpg)
![](https://tutorialslink.com/Article_img/Blog_image/cce4cfeb-e958-4dda-9dfe-87826aa12e2f.jpg)
- For extracting hour, minute, seconds from a given time we have predefined functions provided by excel.
- HOUR – It is used to extract hours from given time. It takes one argument.
OUTPUT
![](https://tutorialslink.com/Article_img/Blog_image/d7468067-1cf1-4a38-8df7-6c1520e6d371.jpg)
![](https://tutorialslink.com/Article_img/Blog_image/1420bd56-0e9a-4bd4-8741-dea093a51536.jpg)
- MINUTE- It is used to extract minutes from given time. It takes one argument.
OUTPUT
![](https://tutorialslink.com/Article_img/Blog_image/6becd29e-0e84-42df-bb18-8284c246239b.jpg)
![](https://tutorialslink.com/Article_img/Blog_image/c7bc3c8b-8ffa-4e0d-8fc8-57f65a360f07.jpg)
- SECONDS- It is used to extract seconds from given time. It takes one argument.
OUTPUT
![](https://tutorialslink.com/Article_img/Blog_image/b71509ed-a2c6-4eb0-aa9e-6e839309dea3.jpg)
![](https://tutorialslink.com/Article_img/Blog_image/1c18bf9b-f0bc-40cc-acb9-2ad57133d902.jpg)
- NETWORKDAYS
It is used to get the total working days between start and end date excluding holidays.
![](https://tutorialslink.com/Article_img/Blog_image/7ede0033-4241-4dd5-84fe-f8c1264ab508.jpg)
OUTPUT
It gives the working days between start and end date excluding holidays.
![](https://tutorialslink.com/Article_img/Blog_image/3ca2d70f-4b73-403e-9d97-b3a6951a025f.jpg)
- WEEKDAY
It returns the week number corresponding to week of year. It returns numbers in range (1-54). It takes two arguments serial number and return type. You can choose the return type
Number (2) corresponds:
1 will represent Monday, 2 will represent Tuesday and so on till Sunday
![](https://tutorialslink.com/Article_img/Blog_image/423eeb49-a1ca-48a5-82f5-411d5b5ee86c.jpg)
OUTPUT
![](https://tutorialslink.com/Article_img/Blog_image/73861005-810f-464c-b4a5-905fca623b79.jpg)