DateAdd

[Anonymous]

Good morning,

I want to add 1 month to my column "birthday date" so I tried to use the function DateAdd but I got blank space for some value in my new column. Indeed I see in internet that it only work if the date calculated is already in my column "birthday date". Do you know how can I do to still have my columns with birthday date +1 month even if it's not contains in my "birthday date"?

Thank you!

Best regards

[Anonymous · Accepted solution]

I found a solution, I use the founction EDATE(date,nbreofmonth) and it works perfectly

Thank you

[selimovd]

Hey @Anonymous ,

what should it show if there is no birthday date?

Best regards

Denis

[Anonymous]

Hello @selimovd , normally there are always a birthday date but if it's not the case maybe a blank or a 0 ?

Thank you