अगर आप Microsoft Excel चलाते है या फिर इक्सेल को चलना सीख रहे है ये पोस्ट आपके लिए ही है, क्योंकि मे आपके लिए कुछ MS Excel Date and Time Functions हिन्दी मे ले कर आया हु, जोकी आपको बहुत काम आने वाले है।
MS Excel Date and Time Function in Hindi
अगर आप Ms Excel मे Date and Time या कोई ऐसा काम करते है जहा Finance या Insurance को ले के excel sheet बनानी पड़ती है तो नीचे दिए गए Date and Time Function आपके काम को बहुत ही आसान बना सकते है।
Function | Description |
---|---|
DATE function | Returns the serial number of a particular date |
DATEDIF function | Calculates the number of days, months, or years between two dates. This function is useful in formulas where you need to calculate an age. |
DATEVALUE function | Converts a date in the form of text to a serial number |
DAY function | Converts a serial number to a day of the month |
DAYS function | Returns the number of days between two dates |
DAYS360 function | Calculates the number of days between two dates based on a 360-day year |
EDATE function | Returns the serial number of the date that is the indicated number of months before or after the start date |
EOMONTH function | Returns the serial number of the last day of the month before or after a specified number of months |
HOUR function | Converts a serial number to an hour |
ISOWEEKNUM function | Returns the number of the ISO week number of the year for a given date |
MINUTE function | Converts a serial number to a minute |
MONTH function | Converts a serial number to a month |
NETWORKDAYS function | Returns the number of whole workdays between two dates |
NETWORKDAYS.INTL function | Returns the number of whole workdays between two dates using parameters to indicate which and how many days are weekend days |
NOW function | Returns the serial number of the current date and time |
SECOND function | Converts a serial number to a second |
TIME function | Returns the serial number of a particular time |
TIMEVALUE function | Converts a time in the form of text to a serial number |
TODAY function | Returns the serial number of today’s date |
WEEKDAY function | Converts a serial number to a day of the week |
WEEKNUM function | Converts a serial number to a number representing where the week falls numerically with a year |
WORKDAY function | Returns the serial number of the date before or after a specified number of workdays |
WORKDAY.INTL function | Returns the serial number of the date before or after a specified number of workdays using parameters to indicate which and how many days are weekend days |
YEAR function | Converts a serial number to a year |
YEARFRAC function | Returns the year fraction representing the number of whole days between start_date and end_date |
MS Excel Date and Time Functions PDF Download
MS Excel Date and Time Function की PDF को डाउनलोड करना चाहते है तो हमारे Telegram Group से जुड़ कर आसानी से Excel Pdf को अपने मोबाईल computer मे डाउनलोड कर सकते है।
हमने यहा पर लगभग सभी MS Excel के Date and Time के Functions को हिन्दी मे इस लिस्ट मे समिल किया है, अगर आपके पास कोई Function है जोकी इस लिस्ट मे समिल हो सके तो हमे Comment मे बताए।
- MS Excel Logical Functions PDF List Download
- MS Excel Compatibility Functions List PDF Download
- MS Excel Engineering Functions List PDF Download
- MS Excel Statistical Functions List PDF Download
- MS Excel Text Functions List PDF Download
- MS Excel Financial Functions List PDF Download
- MS Excel Database Functions in Hindi
- MS Excel Date and Time Functions
- MS Excel Web Functions PDF Download
- MS Excel Lookup and Reference Functions List PDF Download
- MS Excel Math and Trigonometry Functions List PDF Download