Formulas and Functions
આ કંટ્રોલમાં ફેરફાર કરવાથી આ પેજ ઑટોમૅટિક રીતે અપડેટ થઈ જશે.

EDATE

The EDATE function returns a date/time value that is some number of months before or after a given date.

EDATE(start-date, month-offset)

start-date: The starting date. start-date is a date/time value (the time portion is ignored) or date string.

month-offset: The number of months before or after the starting date. month-offset is a number value. A negative month-offset is used to specify a number of months before the starting date and a positive month-offset is used to specify a number of months after the starting date.

Examples

=EDATE("15/01/2000",1) returns 15 Feb 2000, the date one month later.

=EDATE("15/01/2000",-24) returns 15 Jan 1998, the date 24 months earlier.

See alsoEOMONTH
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
મદદરૂપ થયું?
અક્ષરની સીમા 250
મહત્તમ અક્ષરની સીમા 250 છે.
તમારા પ્રતિસાદ બદલ ખૂબ ખૂબ આભાર.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.