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)
Hi, I’m Narinder Kumar, founder of BlogsBuz.com. I create articles and generate celebrity biographies, providing verified, up-to-date content. As an SEO expert and online tools creator, I also share practical tips on making money online, finance management, blogging, and passive income. My mission is to provide accurate information and keep you away from fake content, ensuring you stay well-informed and make smart decisions online.