3.10 Date Functions: TODAY, NOW, DATE, DAY/MONTH/YEAR, EOMONTH, EDATE
| Function | Example | Result |
|---|---|---|
TODAY() |
=TODAY() |
today's date (changes daily) |
NOW() |
=NOW() |
date and time (IST on an IST computer) |
DATE(year, month, day) |
=DATE(2026,11,8) |
08-11-2026 |
DAY / MONTH / YEAR |
=MONTH(B2) |
11 |
EOMONTH(start, months) |
=EOMONTH(B2,0) |
30-11-2026 |
EDATE(start, months) |
=EDATE(B2,3) |
02-02-2027 |
TEXT(date,"mmmm") |
=TEXT(B2,"mmmm") |
November |
Useful patterns
| Need | Formula |
|---|---|
| First day of the month | =EOMONTH(B2,-1)+1 |
| Days since order | =TODAY()-B2 |
| Financial year (Apr–Mar) label | ="FY "&IF(MONTH(B2)>=4,YEAR(B2),YEAR(B2)-1)&"-"&RIGHT(IF(MONTH(B2)>=4,YEAR(B2)+1,YEAR(B2)),2) → FY 2026-27 |
| Quarter (calendar) | ="Q"&ROUNDUP(MONTH(B2)/3,0) → Q4 |
Ravindra Bagale's Tip
TODAY aani NOW volatile (प्रत्येक बदलावर पुन्हा गणना होणारे) aahet – file ughadli ki value badalte. Khup students invoice date sathi TODAY vapartat aani udya ti date badalte! Fixed date havi asel tar Ctrl + ; (date) aani Ctrl + Shift + ; (time) ne type kara.
Practice task
For each order compute: month name, month-end date, financial-year label and the date 7 days later (a return deadline).