AddYears

Description of formula:
Returns a new DateTime that is a result of adding years to another date with time.
Syntax:
ADDYEARS(date|datetime|utc, number)
Parameters:
date (Date)
A chosen date to which years can be added.
datetime (DateTime)
A chosen date with time to which years can be added.
utc (UTC)
A chosen date with time in UTC format to which years can be added.
number (Number)
A number of years. Parameter value can be negative or positive.
Returned type:
Date
examples:
=addyears(date(1999, 1, 1),1)
=addyears(Section1.A1,14)
=addyears(A,-1)
=addyears(B3, C1+3)
=addyears(datetime(2016, 1, 1,12,15),1)
=addyears(UTC(A1),3)
 
 
 
 
Opis formuły:
Zwraca datę z dodaną do niej określoną liczbą lat.
Składnia:
ADDYEARS(date|datetime|utc, number)
Parametry:
date (Date)
wybrana data do której chcemy dodać lata.
datetime (DateTime)
wybrana data z czasem do której chcemy dodać lata.
utc (UTC)
wybrana data z czasem w formacie UTC do której chcemy dodać lata.
number (Number)
Liczba lat do dodania. Wartość parametru może być negatywna lub pozytywna.
Typ zwracanej wartości:
Date
przykłady:
=addyears(date(1999, 1, 1),1)
=addyears(Section1.A1,14)
=addyears(A,-1)
=addyears(B3, C1+3)
=addyears(datetime(2016, 1, 1,12,15),1)
=addyears(UTC(A1),3)
 
 
 
 
Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk