Scribd
Upload
64 views

Date-and-Time-Functions in Excel

Uploaded by

ramkumarls
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
64 views

Date-and-Time-Functions in Excel

Uploaded by

ramkumarls
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 9

6/30/2024 6:30 6/30/2024 6:30

6/30/2024 6/30/2024
Now() and TODAY() Function
=YEAR(),MONTH(),DAY(),DATE()

Date YEAR MONTH DAY DATE


14-Nov-18 2018 11 14 11/14/2018
23-Apr-12 2012 4 23 4/23/2012
20-Feb-00 2000 2 20 2/20/2000
4-Oct-95 1995 10 4 10/4/1995
=HOUR,MINUTE,SE
TIME HOUR MINUTE SECOND TIME
10:00 AM 10 0 0 10:00 AM
11:30 AM 11 30 0 11:30 AM
3:05:03 3 5 3 3:05 AM
5:15 PM 17 15 0 5:15 PM
=HOUR,MINUTE,SECOND and TIME Functions
Start Months EDATE EOMONTH
20-Mar-10 6 20-Sep-10 30-Sep-10
11-Aug-13 -6 11-Feb-13 28-Feb-13
30-Nov-15 12 30-Nov-16 30-Nov-16
10-Jan-17 0 10-Jan-17 31-Jan-17
7-May-18 9 7-Feb-19 28-Feb-19
19-Jul-20 24 19-Jul-22 31-Jul-22
=EDATE and EOMONTH Functions
Week 52
53
Date WEEKDAY WEEKNUM Week
11-Nov-18 1 46 Mon 1 7
12-Nov-18 2 46 Tues 2 1
1-Jan-19 3 1 Wed 3 2
1-Feb-19 6 5 Thr 4 3
Fri 5 4
Sat 6 5
Sun 7 6
3
4
5
6
7
1
2

You might also like