TODAY() =TODAY : Current date volatile

NOW() =NOW() : Current date & time

DATE() =DATE(2025,4,23) -- Construct date

DATEVALUE() =DATEVALUE("23-Apr-2025") : Convert text to date

TIME() =TIME(14,30,0) : Construct time

TIMEVALUE() =TIMEVALUE("14:30") : Convert text to time.

YEAR() =YEAR(A2) : Extract year

MONTH() =MONTH(A2) : Month number

DAY() =DAY(A2) : Day of month

WEEKDAY() =WEEKDAY(A2,2) : Weekday index

WEEKNUM() =WEEKNUM(A2,21) : ISO week number

EOMONTH() =EOMONTH(A2,0) : Last day of month

EDATE() =EDATE(A2,3) :Shift date by months

DAYS() =DAYS(B2,A2) : Days between dates

NETWORKDAYS() =NETWORKDAYS(A2,B2) : Workdays between

NETWORKDAYS.INTL() =NETWORKDAYS.INTL(A2,B2,"0000011") : Custom weekend schedule

WORKDAY() =WORKDAY(A2,5) : Future workday excluding weekends

WORKDAY.INTL() =WORKDAY.INTL(A2,10,"0000011") : Workday with custom weekend

YEARFRAC() =YEARFRAC(A2,B2) : Fractional years between

HOUR() =HOUR(B2) : Hour part

MINUTE() =MINUTE(B2) : Minute part

SECOND() =SECOND(B2) : Second part