Manuals/calci/EDATE

From ZCubes Wiki
Jump to navigation Jump to search
EDATE (start_date,months)


  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} is the starting date
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} is the number of months with Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle +} or Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle -}
    • EDATE(), returns the serial number of the date that is the indicated number of months before or after the start date.


Description

  • This function gives the date that is mentioned number of months before or after a specified Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} .
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} must be entered in DATE function format or we can enter with in double quotes(" ").For e.g EDATE("1/2/1990",2).
  • Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} represents the number of months before or after the start date Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} .
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} is positive then the function will display after the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} or future date
  • If Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months} is negative then the function will display before the Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date} or past date.
  • It is used to calculate maturity dates or due dates that fall on the same day of the month as the date issue.
  • We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
  • This function will show the result as error when
1.The Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle start-date}
 is not a valid date, or if it is not in the DATE function format.
2.Failed to parse (MathML with SVG or PNG fallback (recommended for modern browsers and accessibility tools): Invalid response ("Math extension cannot connect to Restbase.") from server "https://wikimedia.org/api/rest_v1/":): {\displaystyle months}
 is not an Integer.

Examples

  1. EDATE("1/1/1910",2) = 03/01/1910
  2. EDATE("5/4/1897",5) = 10/04/1897
  3. EDATE(TODAY()) = 02/23/2022
  4. EDATE(TODAY(),2.5) = 05/08/2022
  5. EDATE(TODAY(), 2,"week") = 03/09/2022
  6. EDATE(TODAY(), 2.5,"week") = 03/12/2022
  7. EDATE(TODAY(), -13.5,"week") = 11/20/2021
  8. EDATE(NOW(),1,"week") = 03/02/2022
  9. EDATE(NOW(),1..5,"quarter")
start_date months otherperiodtag EDATE
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) 1 quarter 05/23/2022
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) 2 quarter 08/23/2022
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) 3 quarter 11/23/2022
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) 4 quarter 02/23/2023
Wed Feb 23 2022 14:16:56 GMT+0530 (India Standard Time) 5 quarter 05/23/2023

Related Videos

EDATE

See Also

References



Retrieved from "http://wiki.zcubes.com/index.php?title=Manuals/calci/EDATE&oldid=216903"