Excel Formulas Cheat Sheet

Master Excel with our comprehensive formulas reference guide. From basic math to advanced lookup functions, find syntax, examples, and expert tips for all essential Excel formulas.

Found 5 formulas matching "NOW"

Excel Mastery Guide

Beginner

Start with basic calculations and data organization

• SUM, AVERAGE, COUNT
• Basic IF statements
• Text functions (CONCATENATE, LEN)
• TODAY, NOW functions

Intermediate

Master lookup functions and data analysis

• VLOOKUP, HLOOKUP
• Nested IF statements
• AND, OR functions
• Date calculations

Advanced

Advanced functions and financial modeling

• INDEX-MATCH combinations
• Array formulas
• Financial functions (PV, FV, PMT)
• Statistical analysis

Excel Pro Tips

F4 Key: Toggle between absolute and relative references ($A$1, A$1, $A1, A1)

Ctrl + Shift + Enter: Enter array formulas (older Excel versions)

F9 Key: Calculate formulas manually when set to manual calculation mode

Ctrl + `: Toggle between formula view and result view

NOW()

Date & Time

Returns current date and time

Syntax:

=NOW()

Examples:

=NOW()

Current date and time

=NOW()+1

Same time tomorrow

=INT(NOW())

Current date only (removes time)

Note: Updates automatically and includes time

HOUR()

Date & Time

Extracts hour from a time

Syntax:

=HOUR(serial_number)

Examples:

=HOUR(NOW())

Current hour (0-23)

=HOUR(A1)

Hour from time in cell A1

=HOUR("2:30 PM")

Returns 14

Note: Returns hour in 24-hour format (0-23)

MINUTE()

Date & Time

Extracts minute from a time

Syntax:

=MINUTE(serial_number)

Examples:

=MINUTE(NOW())

Current minute (0-59)

=MINUTE(A1)

Minute from time in cell A1

=MINUTE("2:30 PM")

Returns 30

Note: Returns minute (0-59)

SECOND()

Date & Time

Extracts second from a time

Syntax:

=SECOND(serial_number)

Examples:

=SECOND(NOW())

Current second (0-59)

=SECOND(A1)

Second from time in cell A1

=SECOND("2:30:45 PM")

Returns 45

Note: Returns second (0-59)

SWITCH()

Advanced Functions

Evaluates expression against list of values and returns result

Syntax:

=SWITCH(expression, value1, result1, [value2, result2], ..., [default])

Examples:

=SWITCH(A1, 1, "One", 2, "Two", 3, "Three", "Other")

Convert numbers to words

=SWITCH(WEEKDAY(TODAY()), 1, "Sunday", 7, "Saturday", "Weekday")

Check if weekend

=SWITCH(LEFT(A1,1), "A", "Apple", "B", "Banana", "Unknown")

Based on first letter

Note: Available in Excel 2016+. Cleaner alternative to nested IF statements

Master Excel formulas with practice and repetition. Bookmark this page for quick reference!

📊 102 Total Formulas 🏷️ 10 Categories ⚡ Quick Search