Required Function Result
Today's Date =TODAY() 10/18/2024
Current Date & Time =NOW() 10/18/2024 4:14
Practice on your own:
Required Function Result
Today's Date =TODAY()
Current Date & Time =NOW()
Date Function Result
8/7/2021 =YEAR 2021
12/10/2014 =MONTH 12
11/6/1999 =DAY 6
Practice on your own:
Date Function Result
8/7/2021 =YEAR
12/10/2014 =MONTH
11/6/1999 =DAY
Time 8:16:32
Function =HOUR =MINUTE =SECOND
Result 8 16 32
Practice on your own:
Time 9:44:47
Function =HOUR =MINUTE =SECOND
Result
Year 2012
Month 12
Day 21
=DATE 12/21/2012
Practice on your own:
Year 2016
Month 6
Day 15
=DATE
Hour 16
Minute 24
Second 58
=Time 4:24:58 PM
Practice on your own:
Hour 18
Minute 54
Second 20
=Time
Customer name due date for payment date today
Aaron 3/25/2024 10/18/2024
Big Joe 4/4/2024 10/18/2024
Charles 5/6/2024 10/18/2024
Danny 7/24/25 10/18/2024
Ethan 5/25/2024 10/18/2024
Freddy 12/31/2023 10/18/2024
Garfield 7/8/2024 10/18/2024
helen 5/2/2024 10/18/2024
Ijas 6/6/2024 10/18/2024
1. Find those who are late by more than 90 business days and highlight in red using CF
2.find those who are late by more than 90 days and highlight in any color using CF
3.count them
late more than 90 Business days late more than 90 days
use net working days use days function and absolute if necessary
joining date salary rating app date months_diff factor check new_salary
10/7/2023 $30,000.00 good 11/1/2023
4/5/2023 $300,000.00 good 11/1/2023
4/3/2023 $500,000.00 good 11/1/2023
4/3/2023 $322,943.00 okay 11/1/2023
4/1/2023 $322,942.00 okay 11/1/2023
3/31/2023 $322,941.00 good 11/1/2023
3/27/2023 $322,940.00 okay 11/1/2023
9/4/2023 $322,939.00 bad 11/1/2023
5/5/2023 $322,938.00 good 11/1/2023
10/7/2023 $322,937.00 good 11/1/2023
3/22/2023 $322,936.00 good 11/1/2023
3/22/2023 $322,935.00 bad 11/1/2023
find new salary after appraisal
condition 1 : greater than or equal to 6 months
condition 2 : good rating only and okay
condition 3: good is 30%,okay is 15% and bad is no change 30% = 1.3
15 % =1.15
Use function datedif for E
use nested if for F
Use if & and for G
Use if for H
John's birthday is after 18 days from today ? 11/5/2024
john's anniversary was 5 months ago 5/18/2024
my house loan is due since 21 days . 9/27/2024
how many days are left for your X'mas holidays?
I pay emi per quarter ,when will I pay next ? 1/18/2025
liza was born on 4/5/2006. when will she be 5 and half years old ? 10/5/2011
use of end date function for months
I have to go for training after every 4 days ,when ?
Friday, October 18, 2024
Tuesday, October 22, 2024
Saturday, October 26, 2024
Wednesday, October 30, 2024
Sunday, November 3, 2024
Thursday, November 7, 2024
Monday, November 11, 2024
Friday, November 15, 2024
Tuesday, November 19, 2024
Saturday, November 23, 2024
Wednesday, November 27, 2024
Sunday, December 1, 2024
Thursday, December 5, 2024
Monday, December 9, 2024
