Knowledge Hub / Microsoft Excel

Excel date, time and text formulas for planners

🔒 Members

TODAY, NOW, DAY, MONTH, YEAR, WEEKDAY, date differences, TEXT for time formats, CEILING for rounding to cartons or bundles, and LEN, SUBSTITUTE, FIND, LEFT and RIGHT for cleaning text.

2 min read · Updated 08 Oct 2026 · By Md. Saiful Islam · বাংলায় পড়ুন

Dates

FormulaReturns
=TODAY()Today's date (updates every day)
=NOW()Date and current time
=DAY(A2) / =MONTH(A2) / =YEAR(A2)Day, month or year number
=WEEKDAY(A2, 1)1 = Sunday … 7 = Saturday
=B2-A2Days between two dates
=DAYS360(A2, B2)Days on a 360-day accounting year
=MONTH(B2)-MONTH(A2)Month difference (same year)
=YEAR(B2)-YEAR(A2)Year difference

Tip: Excel stores a date as a number of days and the time as a fraction of a day. That is why =NOW()+1 is the same time tomorrow, and (Stop−Start)*24 gives hours.

WEEKDAY in planning: =IF(WEEKDAY(A2,1)=6, "Friday - off", "") flags weekly holidays in a production calendar.

🔒

Continue reading as a member

This lesson is for registered members. Register, pay with bKash, and get full access to all member lessons and files.

Create account Member login
Keep learning

More in Microsoft Excel

Microsoft Excel

EXACT Function in Excel

Compare text case-sensitively with EXACT.

1 min read · 17 Oct 2026
Microsoft Excel

VLOOKUP Function in Excel

VLOOKUP searches the first column of a table and returns a value from another column.

1 min read · 17 Oct 2026
Microsoft Excel

TRIM Function in Excel

TRIM removes extra spaces from text.

1 min read · 17 Oct 2026

Get one practical IE tip every week

Join IE and production professionals learning with in2eff.