एम एस एक्सेल मे date को शब्दों मे कैसे लिखें केवल एक बार फंक्शन का प्रयोग कर

आप फंक्शन का प्रयोग करके date को शब्दों मे लिख सकते है निचे मैंने एक उदाहरण लिया है जिसमे लिखें गए टेक्स्ट को पर्टिकुलर सेल मे शब्दों मे कैसे लिख सकते है इसके बारे मे बताऊंगा अब इसमें दिए गए date को उसके सामने सेल मे day, month aur year me शब्दों  me कैसे लिखें ये बताऊंगा 
इसके लिए day के निचे वाले सेल पर क्लिक करें और फंक्शन लिखें =text(A1, "dddd")
तो day के निचे वाले सेल मे शब्दों मे दिन आ जाएगाअब  month के लिए month के निचे वाले सेल मे जाकर लिखें
=text(A1,"mmmm")
और year ke लिए year के निचे वाले सेल मे जाकर लिखें
=text(A1,"yyyy")

Comments

Post a Comment

Popular posts from this blog

Add two number in Scratch

Image
15.04.2023 Computer Science Secondary School answered Scratch program for sum of two numbers ​ See what the community says and unlock a badge.  to add comment Play Unmute bindroomonika01 is waiting for your help. Add your answer and earn points. Answer No one rated this answer yet —  why not be the first?  😎 Ambitious 15  answers 961  people helped Answer: Here's an example scratch program for finding the sum of two numbers. Explanation: First, drag and drop two "ask" blocks from the “Sensing” category and place them below the “when green flag clicked” block. Change the prompt text on both ask blocks to "Enter a number" and "Enter another number". Drag and drop a "set" block from the “Variables” category, and change the variable name to "num1". Place it under the first "ask" block, and set its value to "answer". Repeat step 3, but change the variable name to "num2" and place it under the second "...
Read more

What is soft skill

  oft skills are  personal attributes and behaviors that help people interact with others in a social or workplace setting .  They are also known as interpersonal skills, essential skills, or noncognitive skills.   Soft skills are important for: Building relationships, Communicating effectively, Solving problems, Collaborating with others, and Contributing to a positive work environment.   Examples of soft skills include: Communication, Teamwork, Problem solving, Adaptability, Critical thinking, Time management, Leadership, Creativity, Emotional intelligence, and Listening.  
Read more

what is scratch programing

Scratch coding is defined as the process of writing and running programs using Scratch, a free programming language and code editor that helps young learners understand coding logic using blocks and visual aids. This article defines the concept of Scratch coding and its uses in computer science and programming. Scratch coding is the process of writing and running programs using Scratch, a free programming language and code editor that helps young learners understand coding logic using blocks and visual aids.  Scratch is a programming platform for children which was created by the MIT Media Lab in 2007. Here are the main features of Scratch: Teaches children how to write code in a visually eloquent manner.  Offers block-based coding, allowing learners to arrange pre-written instructions to generate actions.  Helps users work together, think imaginatively, and analyze methodically.  Allows them to create animations and graphics that can be shared after a project has be...
Read more