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
                                      .
   41   42   43   44   45   46   47   48   49   50   51