Page 46 - Play v1.0 gujarati class 7
P. 46
Œkhe¾ y™u ‚{Þ Vtõþ™ (Date and Time Functions)
Functions Purpose Example
Input: =TODAY()
TODAY() Œu ðŒo{k™ íkkhe¾ …hŒ fhu Au. Output: 7/23/2019
Input: =MONTH(TODAY())
MONTH(TODAY()) Œu [k÷w {rn™ku …hŒ fhu Au. Output: 7
Input: =YEAR(TODAY())
YEAR(TODAY()) Œu [k÷w ð»ko …hŒ fhu Au Output: 2019
Input: =DAY(TODAY())
DAY(TODAY()) Œu ðŒo{k™ rËð‚ …hŒ fhu Au Output: 23
Input: = NOW()
NOW() Œu r‚Mx{™e ðíko{kLk Œkhe¾ y™u ‚{Þ yk…u Au. Output: 21-05-2020 11:24
Input: = HOUR(NOW())
HOUR(time) Œu yk…u÷ ‚{ÞÚke f÷kf yk…u Au. Output: 11
Input: MINUTE(NOW())
MINUTE(time) Œu yk…u÷ ‚{ÞÚke r{rLkx yk…u Au. Output: 24
[k÷ku MS Excel{kt Œkhe¾ Vtõþ™ku™ku W…Þku„ ™e[u™k …„÷ktyku y™w‚he™u fheyu:
…„÷wt 1 ‚u÷{kt xkR… fhku = TODAY ().
…„÷wt 2 feƒkuzo{ktÚke yuLxh fe ˃kðku.
ßÞkhu Œ{u yuLxh fe ˃kðku Aku, íÞkhu ‚u÷{kt ðŒo{k™ Œkhe¾ Ëu¾kÞ Au. TODAY VtõþLkLkku WÃkÞkuøk fhðku
…„÷wt 3 ‚u÷{kt xkR… fhku = MONTH (TODAY ()) Vtõþ™ y™u feƒkuzo{ktÚke (Using TODAY function)
yuLxh fe ˃kðku.
ðŒo{k™ Œkhe¾™ku {rn™ku Ëu¾kþu. y{u MONTH Vtfþ™{kt Œkhe¾ ÄhkðŒk
fku»k™ku ‚t˼o …ý yk…e þfeyu Aeyu. yu s heŒu, y{u ð»ko y™u rËð‚ y™w¢{u
Œkhe¾Úke {u¤ððk {kxu YEAR () y™u DAY () Vtõþ™ ™ku W…Þku„ fhe þfeyu MONTH VtõþLkLkku WÃkÞkuøk fhðku
Aeyu. (Using MONTH function)
íkfLkefe
¿kkLk
‚k{kLÞ Vtõþ™ suðk fu SUM, AVERAGE, MAX, MIN AUTOSUM
f{kLz {kt zkW™ yuhku ™ku W…Þku„ fhe™u ðk…he þfkÞ Au..
ƒeò ðÄkhk™k Vtõþ™ ðk…hðk {kxu MORE FUNCTION rðfÕ… …h
Âõ÷f fhku.
44 M od ul ar ( V er 1 . 0 ) - V I I
.

