The AND GIVE The function uses the following syntax to operate:
EDATE (start date, months)
The AND GIVE The function has the following arguments:
- start date: this is mandatory and represents the start date. Dates must be entered using the DATE function, or as a consequence of other formulas or functions. As an example, consider using DATE(2020,5,23) For the day 23 May 2020. Problems can arise if dates are entered as text
- months: this is also necessary. This represents the number of months before or after the start date. A positive value for months results in a future date; a negative value results in a past date.
It should be noted at the same time that:
- Excel stores dates as sequential serial numbers so they can be used in calculations.. The 1 of January of 1900 is the serial number 1 and the 6 July 2009 is the serial number 40000 because it is 39,999 days after 1 of January of 1900.
- And start date is not a valid date, AND GIVE return the #VALUE! error value
- And months it is not a whole number, is truncated
- you will need to change the format of the number (CTRL + 1, 'Cell format') to display a suitable date
- The 29 February 1900 recognized as day 60 in the date system 1900. This date does not exist (years ending in “00” must be divisible by 400 to be a leap year), but this bug has been perpetuated for consistency / compatible con Lotus 1-2-3.
Please, see my example below: