Most Powerful Formulas in MS Excel:-
One of the most widely used data management programs worldwide is Microsoft Excel. We can largely attribute its success to the ease of formulas construction. This accessibility enables us to manage a large amount of data and get the outcomes that we need. Excel has numerous functions ready to process your data and deliver the desired results. Learn about each one and become familiar with it.
11. NOW
The current date and time on the system may be obtained from Excel by using the NOW() function.
NOW =(NOW()
12. TODAY
TODAY =TODAY()
The TODAY() function in Excel is responsible for displaying the current date on the system.
13. DAY
DAY =DAY(TODAY())
14. MONTH
MONTH =MONTH(TODAY())
15. YEAR
YEAR =(TODAY())
16. TIME
TIME =TIME(24,54,30)
17. HOUR
HOUR =HOUR(NOW())
18. MINUTE
MINUTE =MINUTE(NOW())
19. SECOND
SECOND =SECOND(NOW())
20. DATEDIF
DATEDIF =IF(C2>50,”PASS”,”FAIL”)
Read also: Most Powerful Formulas in MS Excel. (Lession- 18)
I am expert skilled in SEO content Creation. My name is Narinder Kumar. I have an experience in creating websites, (SEO) Content Creation , Articles Blogs & more. Currently I prepared a SEO Content in Eduction Purpose, Entertainment, Finance Management etc.