Now,Today,Datedif,Power,SQRT,Fact,Nestedif,Days360 Function in Excel

 

Now Function

=NOW()

Current Date and Time Show them.

Today Function

 

=DATEDIF(A2,TODAY(),"y")

 

	A	B
1	Date of Birth	Age (Year)
2	9/15/1990	33
3	10/8/1990	33
4	6/16/1988	35
5	8/15/1947	76
6	5/16/1992	31

 

Datedif Function

 

=DATEDIF(A2,TODAY(),"y")

 

	A	B
1	Date	Date of Birth
2	2/2/1988	35
3	1/3/1985	38
4	9/6/1952	71
5	9/9/2000	23
6	2/2/1989	34

 

Power Function

Power

=POWER(A2,2)

Cube

=POWER(A2,3)

 

	A	B	C
1	Number	Power	Cube
2	5	25	125
3	7	49	343
4	16	256	4096
5	25	625	15625

 

SQRT Function

 

=SQRT(A2)

 

	A	B
1	Number	SQRT
2	625	25
3	729	27
4	256	16
5	15625	125

 

Fact Function

 

=FACT(A2)

 

	A	B
1	Number	Factorial
2	7	5040
3	8	40320
4	9	362880
5	6	720

 

Nested If Function

 

=IF(B2>=85,"A+",IF(B2>=75,"A",IF(B2>=65,"B",IF(B2>=33,"C","Fail"))))

 

	A	B	C
1	Name	Percentage	Grade
2	Raman	85	A+
3	Ravi	65	B
4	Kajal	45	C
5	Daya	23	Fail

 

Days360 Function

=DAYS360(A2,B2)/365

 

	A	B	C
1	DOB	Present date	Age
2	9/15/1990	10/31/2023	32.6739726
3	10/8/1990	10/31/2023	32.6109589
4	6/16/1988	10/31/2023	34.89041096
5	8/15/1947	10/31/2023	75.16712329
6	5/16/1992	10/31/2023	31.02739726