Difference between revisions of "Manuals/calci/ADDDATE"

From ZCubes Wiki
Jump to navigation Jump to search
Line 23: Line 23:
#ADDDATE("28/7/2009[DD/MM/YYYY]",0,0,5)="1975-01-01T00:00:00.000Z"(To use DD/MM/YYYY Format]
#ADDDATE("28/7/2009[DD/MM/YYYY]",0,0,5)="1975-01-01T00:00:00.000Z"(To use DD/MM/YYYY Format]
==Related Videos==
{{#ev:youtube|v=py0FWdN255c|280|center|Adding date}}
==See Also==
==See Also==

Latest revision as of 15:29, 7 February 2019

ADDDATE (Date,Days,Months,Years)

  • is any date.
  • is number of days to be added.
  • is number of months to be added.
  • is number of years.


  • This function used to add dates,months and year to given date.
  • In , is any date in which number of day to added.
  • is the number of days to be added.
  • is the number months to be added to the given date.
  • is the number of year to be added.
  • Using this function we can add or subtract the number of days to the given date.
  • Day values can be positive or negative.
  • We can use the DD/MM/YYYY format also. For Example:"14/5/2005[DD/MM/YYYY]".
  • We can use Range values also. For Example: ADDDATE(#3/10/2016-5/10/2016,30,2,0)
  • #date notation needs mm/dd/yy format .


  1. ADDDATE("3/10/2016",45,2,0) = 2016-06-23T18:30:00.000Z
  2. ADDDATE("10/5/2020",240,6,2) = 2023-12-01T18:30:00.000Z
  3. ADDDATE("12/10/2060",0,0,5) = 2065-12-09T18:30:00.000Z
  4. ADDDATE("28/7/2009[DD/MM/YYYY]",0,0,5)="1975-01-01T00:00:00.000Z"(To use DD/MM/YYYY Format]

Related Videos

Adding date

See Also