Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

DateAdd

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 w...
Need Help
  • Anonymous's avatar
    Anonymous
    5 years ago

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

    Thank you

selimovd's avatar
selimovd
Most Valuable Professional
5 years ago

Hey Anonymous ,

 

what should it show if there is no birthday date?

 

Best regards

Denis

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

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

    Thank you