Adding Months Would be nice to simply add mo...

Adding Months

Would be nice to simply add months like with the EDATE funktion in EXCEL, or like shown in this Video:

https://www.youtube.com/watch?v=86M3TCpxk2Q

0 6 914
6 REPLIES 6

You can do the same with the concatenate and then choose the Date as a field type.

Itโ€™s not as simple as with Excel or gSheet, but itโ€™s doable.

@Aleksi_Alkio Thank you. But when I add 13 months, it will not increase the year.

When I have [DateTime] = 01/30/2000 and I do DATE((MONTH([DateTime]) +13) & โ€œ/โ€ & (DAY([DateTime])) & โ€œ/โ€ & (YEAR([DateTime]))) It should give me 02/30/2001. But the result is just nothing, because it calculates 14/30/2000 and that is not a date.

You need to check from the month column is it 12 or more and then add more years. You donโ€™t need to do the same with the Days because when you have calculated the month and year, you can just add those days.

Steve
Participant V

EOMONTH() provides a helpful workaround, but it is not a replacement for (or equivaltent to) EDATE() as the table below shows: 

 

Start Date (A)EDATE(A,1)EOMONTH(A,0)+DAY(A)
2/1/20233/1/20233/1/2023
2/28/20233/28/20233/28/2023
1/30/20232/28/20233/2/2023
2/5/20233/5/20233/5/2023
2/1/20233/1/20233/1/2023

This is a list of renewal dates for acutal subscriptions.  In the highlighted example, EDATE() correcly calculates the true renewal date (reported by the vendor); EOMONTH() does not.  Unfortunately, EDATE() calculates the next renewal incorrectly as 3/28/23.  Using EDATE(A,2) with the original Start Date, however, correctly calculates the next renewal as 3/30/23.  This issue surfaces in other end-of-the-month scenarios as well.  I'm not sure if there's an ironclad fix, but having EDATE() directly supported in Appsheet (as it is in Google Sheets) would be a step in the right direction.  Just my two cents'

Top Labels in this Space