1) TODAY = TODAY()
2) DAY = DAY(SELECT DATE)
3) MONTH= MONTH( SELECT DATE)
4) YEAR = YEAR( SELECT DATE)
5) DATE = DATE( SELECT YEAR, MONTH, DAY)
6) NOW = NOW()
7) HOUR = HOUR( SELECT TIME)
8) MINUTE = MINUTE( SELECT TIME)
9) SECOND= SECOND ( SELECT TIME)
10) TIME = TIME(SELECT HOUR, MINUTE, SECOND)
11) NETWORKDAYS = NETWORKDAYS ( SELECT START DATE, END DATE)
12) ABS = ABS( SELECT NEGATIVE NUMBER)
13) YEARFRAC = YEARFRAC ( SELECT START DATE, END DATE)
14) ROUNDUP= ROUNDUP ( SELECT DECIMAL NUMBER,0)
15) ROUNDDOWN= ROUNDDOWN ( SELECT DECIMAL NUMBER,0)
16) CONCATENATE= CONCATENATE ( SELECT TEXT 1, SELECT TEXT 2)
17) PRODUCT= PRODUCT ( SELECT NUMBER 1, NUMBER 2)
18) SUMPRODUCT = SUMPRODUCT (SELECT COLUMN 1, SELECT COLUMN 2)
Post a Comment