# Difference between revisions of "Manuals/calci/ADDDATE"

Jump to navigation
Jump to search

(Created page with "<div style="font-size:30px">'''ADDDATE (Date,Days,Months,Years)'''</div><br/> *<math>Date</math> is any date. *<math>Days</math> is number of days to be added. *<math>Months</...") |
|||

(4 intermediate revisions by the same user not shown) | |||

Line 13: | Line 13: | ||

*Using this function we can add or subtract the number of days to the given date. | *Using this function we can add or subtract the number of days to the given date. | ||

*Day values can be positive or negative. | *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 . | ||

==Example== | ==Example== | ||

Line 18: | Line 21: | ||

#ADDDATE("10/5/2020",240,6,2) = 2023-12-01T18:30:00.000Z | #ADDDATE("10/5/2020",240,6,2) = 2023-12-01T18:30:00.000Z | ||

#ADDDATE("12/10/2060",0,0,5) = 2065-12-09T18:30:00.000Z | #ADDDATE("12/10/2060",0,0,5) = 2065-12-09T18:30:00.000Z | ||

+ | #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.

## Description

- 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 .

## Example

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

## Related Videos

## See Also

## References