Home معادلات إكسيل

كيفية استعمال الدالة AUJOURDHUI في الاكسل

September 17, 2021

كيفية استعمال الدالة AUJOURDHUI في الاكسل

في هذه المقالة سيتم التطرق لشرح كيفية استعمال الدالة AUJOURDHUI والتي تعتبر من الدوال المهمة في الإكسيل.

تعرض وظيفة Excel aujourdhui التاريخ الحالي (يتم تحديثه كل يوم تلقائيًا).

يمكن أيضًا استخدام هذه الوظيفة لحساب الفاصل الزمني بين التاريخ الحالي والتاريخ الذي تختاره.

=AUJOURDHUI()

أمثلة على الاستخدام

للحصول على تاريخ اليوم فقط أدخل =AUJOURDHUI() خلية وستحصل على تاريخ اليوم:

كيفية استعمال الدالة AUJOURDHUI في الاكسل

لحساب عدد الأيام المتبقية قبل التاريخ في الخلية B1 ، أدخل =B1-AUJOURDHUI():

كيفية استعمال الدالة AUJOURDHUI في الاكسل

للحصول على عدد الأيام بدلاً من التاريخ ، قم بتغيير تنسيق الخلية B3

ستحصل بعد ذلك على عدد الأيام المتبقية التي سيتم تحديثها كل يوم.

Tags معادلات إكسيل

Latest articles from : معادلات إكسيل

Comments

No comments

Post a Comment

Reading Mode :

Font Size

+

16

-

lines height

+

2

-

window['__wavt'] = 'AOuZoY5xKYjxTRd93sKr7IcnT6ynmoMVBg:1713904257549';_WidgetManager._Init('//www.blogger.com/rearrange?blogID\x3d7172743834752994373','//www.practiceexcel-365.com/2021/07/excelpractice365.html','7172743834752994373'); _WidgetManager._SetDataContext([{'name': 'blog', 'data': {'blogId': '7172743834752994373', 'title': 'Practice Excel365 | Free Excel Courses', 'url': 'https://www.practiceexcel-365.com/2021/07/excelpractice365.html', 'canonicalUrl': 'https://www.practiceexcel-365.com/2021/07/excelpractice365.html', 'homepageUrl': 'https://www.practiceexcel-365.com/', 'searchUrl': 'https://www.practiceexcel-365.com/search', 'canonicalHomepageUrl': 'https://www.practiceexcel-365.com/', 'blogspotFaviconUrl': 'https://www.practiceexcel-365.com/favicon.ico', 'bloggerUrl': 'https://www.blogger.com', 'hasCustomDomain': true, 'httpsEnabled': true, 'enabledCommentProfileImages': true, 'gPlusViewType': 'FILTERED_POSTMOD', 'adultContent': false, 'analyticsAccountNumber': 'UA-204466697-1', 'encoding': 'UTF-8', 'locale': 'en', 'localeUnderscoreDelimited': 'en', 'languageDirection': 'ltr', 'isPrivate': false, 'isMobile': false, 'isMobileRequest': false, 'mobileClass': '', 'isPrivateBlog': false, 'isDynamicViewsAvailable': true, 'feedLinks': '\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default\x22 /\x3e\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/rss+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - RSS\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/posts/default?alt\x3drss\x22 /\x3e\n\x3clink rel\x3d\x22service.post\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.blogger.com/feeds/7172743834752994373/posts/default\x22 /\x3e\n\n\x3clink rel\x3d\x22alternate\x22 type\x3d\x22application/atom+xml\x22 title\x3d\x22Practice Excel365 | Free Excel Courses - Atom\x22 href\x3d\x22https://www.practiceexcel-365.com/feeds/7502092791079136318/comments/default\x22 /\x3e\n', 'meTag': '', 'adsenseHostId': 'ca-host-pub-1556223355139109', 'adsenseHasAds': true, 'adsenseAutoAds': false, 'boqCommentIframeForm': true, 'loginRedirectParam': '', 'view': '', 'dynamicViewsCommentsSrc': '//www.blogblog.com/dynamicviews/4224c15c4e7c9321/js/comments.js', 'dynamicViewsScriptSrc': '//www.blogblog.com/dynamicviews/32178a08698b1e6b', 'plusOneApiSrc': 'https://apis.google.com/js/platform.js', 'disableGComments': true, 'interstitialAccepted': false, 'sharing': {'platforms': [{'name': 'Get link', 'key': 'link', 'shareMessage': 'Get link', 'target': ''}, {'name': 'Facebook', 'key': 'facebook', 'shareMessage': 'Share to Facebook', 'target': 'facebook'}, {'name': 'BlogThis!', 'key': 'blogThis', 'shareMessage': 'BlogThis!', 'target': 'blog'}, {'name': 'Twitter', 'key': 'twitter', 'shareMessage': 'Share to Twitter', 'target': 'twitter'}, {'name': 'Pinterest', 'key': 'pinterest', 'shareMessage': 'Share to Pinterest', 'target': 'pinterest'}, {'name': 'Email', 'key': 'email', 'shareMessage': 'Email', 'target': 'email'}], 'disableGooglePlus': true, 'googlePlusShareButtonWidth': 0, 'googlePlusBootstrap': '\x3cscript type\x3d\x22text/javascript\x22\x3ewindow.___gcfg \x3d {\x27lang\x27: \x27en\x27};\x3c/script\x3e'}, 'hasCustomJumpLinkMessage': true, 'jumpLinkMessage': 'Read more \xbb', 'pageType': 'item', 'postId': '7502092791079136318', 'postImageThumbnailUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-PXXb-fwNMxMt1gjxBUoItxagRyFpMKE2acyW9Hb87XZbo9wYl5JjEytxMa9Y4TQItD1D6AWii5iiXjR_TUY1MzcCd8Hrf1fD3mEiVaXTgONSiLz1IFTQCufL410_yUGUZd9HrtCRQyU/s72-c/today.png', 'postImageUrl': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-PXXb-fwNMxMt1gjxBUoItxagRyFpMKE2acyW9Hb87XZbo9wYl5JjEytxMa9Y4TQItD1D6AWii5iiXjR_TUY1MzcCd8Hrf1fD3mEiVaXTgONSiLz1IFTQCufL410_yUGUZd9HrtCRQyU/s16000/today.png', 'pageName': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 AUJOURDHUI \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'pageTitle': 'Practice Excel365 | Free Excel Courses: \u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 AUJOURDHUI \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'metaDescription': '\u064a\u0645\u0643\u0646 \u0623\u064a\u0636\u064b\u0627 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0644\u062d\u0633\u0627\u0628 \u0627\u0644\u0641\u0627\u0635\u0644 \u0627\u0644\u0632\u0645\u0646\u064a \u0628\u064a\u0646 \u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0627\u0644\u062d\u0627\u0644\u064a \u0648\u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0627\u0644\u0630\u064a \u062a\u062e\u062a\u0627\u0631\u0647.\n\n\u064a\u0633\u062a\u062e\u062f\u0645 :\n\n \x3dAUJOURDHUI()\n\n'}}, {'name': 'features', 'data': {}}, {'name': 'messages', 'data': {'edit': 'Edit', 'linkCopiedToClipboard': 'Link copied to clipboard!', 'ok': 'Ok', 'postLink': 'Post Link'}}, {'name': 'template', 'data': {'name': 'custom', 'localizedName': 'Custom', 'isResponsive': true, 'isAlternateRendering': false, 'isCustom': true}}, {'name': 'view', 'data': {'classic': {'name': 'classic', 'url': '?view\x3dclassic'}, 'flipcard': {'name': 'flipcard', 'url': '?view\x3dflipcard'}, 'magazine': {'name': 'magazine', 'url': '?view\x3dmagazine'}, 'mosaic': {'name': 'mosaic', 'url': '?view\x3dmosaic'}, 'sidebar': {'name': 'sidebar', 'url': '?view\x3dsidebar'}, 'snapshot': {'name': 'snapshot', 'url': '?view\x3dsnapshot'}, 'timeslide': {'name': 'timeslide', 'url': '?view\x3dtimeslide'}, 'isMobile': false, 'title': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 AUJOURDHUI \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'description': '\u064a\u0645\u0643\u0646 \u0623\u064a\u0636\u064b\u0627 \u0627\u0633\u062a\u062e\u062f\u0627\u0645 \u0647\u0630\u0647 \u0627\u0644\u0648\u0638\u064a\u0641\u0629 \u0644\u062d\u0633\u0627\u0628 \u0627\u0644\u0641\u0627\u0635\u0644 \u0627\u0644\u0632\u0645\u0646\u064a \u0628\u064a\u0646 \u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0627\u0644\u062d\u0627\u0644\u064a \u0648\u0627\u0644\u062a\u0627\u0631\u064a\u062e \u0627\u0644\u0630\u064a \u062a\u062e\u062a\u0627\u0631\u0647.\n\n\u064a\u0633\u062a\u062e\u062f\u0645 :\n\n \x3dAUJOURDHUI()\n\n', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-PXXb-fwNMxMt1gjxBUoItxagRyFpMKE2acyW9Hb87XZbo9wYl5JjEytxMa9Y4TQItD1D6AWii5iiXjR_TUY1MzcCd8Hrf1fD3mEiVaXTgONSiLz1IFTQCufL410_yUGUZd9HrtCRQyU/s16000/today.png', 'url': 'https://www.practiceexcel-365.com/2021/07/excelpractice365.html', 'type': 'item', 'isSingleItem': true, 'isMultipleItems': false, 'isError': false, 'isPage': false, 'isPost': true, 'isHomepage': false, 'isArchive': false, 'isLabelSearch': false, 'postId': 7502092791079136318}}, {'name': 'widgets', 'data': [{'title': 'BlogArchive', 'type': 'BlogArchive', 'sectionId': 'sitting', 'id': 'BlogArchive400'}, {'title': 'BlogLabels', 'type': 'Label', 'sectionId': 'sitting', 'id': 'Label400'}, {'title': 'Pages', 'type': 'PageList', 'sectionId': 'pages', 'id': 'PageList1'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'topsocialL', 'id': 'LinkList3'}, {'title': 'Practice Excel365 | Free Excel Courses (Header)', 'type': 'Header', 'sectionId': 'logo', 'id': 'Header1'}, {'title': '\u0627\u0644\u0642\u0627\u0626\u0645\u0629 \u0627\u0644\u0631\u0626\u064a\u0633\u064a\u0629', 'type': 'LinkList', 'sectionId': 'menu', 'id': 'LinkList22'}, {'title': 'Blog Posts', 'type': 'Blog', 'sectionId': 'Tempnec', 'id': 'Blog1', 'posts': [{'id': '7502092791079136318', 'title': '\u0643\u064a\u0641\u064a\u0629 \u0627\u0633\u062a\u0639\u0645\u0627\u0644 \u0627\u0644\u062f\u0627\u0644\u0629 AUJOURDHUI \u0641\u064a \u0627\u0644\u0627\u0643\u0633\u0644', 'featuredImage': 'https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEj-PXXb-fwNMxMt1gjxBUoItxagRyFpMKE2acyW9Hb87XZbo9wYl5JjEytxMa9Y4TQItD1D6AWii5iiXjR_TUY1MzcCd8Hrf1fD3mEiVaXTgONSiLz1IFTQCufL410_yUGUZd9HrtCRQyU/s16000/today.png', 'showInlineAds': true}], 'headerByline': {'regionName': 'header1', 'items': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}]}, 'footerBylines': [{'regionName': 'footer1', 'items': [{'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}]}, {'regionName': 'footer2', 'items': [{'name': 'labels', 'label': ''}]}], 'allBylineItems': [{'name': 'share', 'label': ''}, {'name': 'timestamp', 'label': '-'}, {'name': 'comments', 'label': 'comments'}, {'name': 'icons', 'label': ''}, {'name': 'labels', 'label': ''}]}, {'title': 'Contact Form', 'type': 'ContactForm', 'sectionId': 'AddOns', 'id': 'ContactForm200'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'sidepar', 'id': 'LinkList4'}, {'title': '\u0645\u0648\u0627\u0642\u0639 \u0627\u0644\u062a\u0648\u0627\u0635\u0644 \u0627\u0644\u0625\u062c\u062a\u0645\u0627\u0639\u064a', 'type': 'LinkList', 'sectionId': 'footer-social', 'id': 'LinkList2'}]}]); _WidgetManager._RegisterWidget('_BlogArchiveView', new _WidgetInfo('BlogArchive400', 'sitting', document.getElementById('BlogArchive400'), {'languageDirection': 'ltr', 'loadingMessage': 'Loading\x26hellip;'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LabelView', new _WidgetInfo('Label400', 'sitting', document.getElementById('Label400'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_PageListView', new _WidgetInfo('PageList1', 'pages', document.getElementById('PageList1'), {'title': 'Pages', 'links': [{'isCurrentPage': false, 'href': 'http://www.practiceexcel-365.com/', 'title': 'Home'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/privacy-policy.html', 'id': '9039293699451073275', 'title': 'Privacy Policy'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/who-are-we.html', 'id': '3848084781500635721', 'title': 'Who We Are'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/contact-us.html', 'id': '5696516493396065643', 'title': 'Contact Us'}, {'isCurrentPage': false, 'href': 'https://www.practiceexcel-365.com/p/blog-page.html', 'id': '4724947008150640905', 'title': 'Frequently Asked Questions'}], 'mobile': false, 'showPlaceholder': true, 'hasCurrentPage': false}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList3', 'topsocialL', document.getElementById('LinkList3'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_HeaderView', new _WidgetInfo('Header1', 'logo', document.getElementById('Header1'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList22', 'menu', document.getElementById('LinkList22'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_BlogView', new _WidgetInfo('Blog1', 'Tempnec', document.getElementById('Blog1'), {'cmtInteractionsEnabled': false, 'lightboxEnabled': true, 'lightboxModuleUrl': 'https://www.blogger.com/static/v1/jsbin/103930930-lbx.js', 'lightboxCssUrl': 'https://www.blogger.com/static/v1/v-css/13464135-lightbox_bundle.css'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_ContactFormView', new _WidgetInfo('ContactForm200', 'AddOns', document.getElementById('ContactForm200'), {'contactFormMessageSendingMsg': 'Sending...', 'contactFormMessageSentMsg': 'Your message has been sent.', 'contactFormMessageNotSentMsg': 'Message could not be sent. Please try again later.', 'contactFormInvalidEmailMsg': 'A valid email address is required.', 'contactFormEmptyMessageMsg': 'Message field cannot be empty.', 'title': 'Contact Form', 'blogId': '7172743834752994373', 'contactFormNameMsg': 'Name', 'contactFormEmailMsg': 'Email', 'contactFormMessageMsg': 'Message', 'contactFormSendMsg': 'Send', 'contactFormToken': 'AOuZoY4xCcPut26X4tWVqnSu-BRm6MJq9g:1713904257550', 'submitUrl': 'https://www.blogger.com/contact-form.do'}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList4', 'sidepar', document.getElementById('LinkList4'), {}, 'displayModeFull')); _WidgetManager._RegisterWidget('_LinkListView', new _WidgetInfo('LinkList2', 'footer-social', document.getElementById('LinkList2'), {}, 'displayModeFull'));