convert date dd/mm/yyyy and edate formula or vba

[rakesh seebaruth]

Dear Guys

Good Morning

I have the following date in the format 2/28/2020(mm/dd/yyyy)

i need to convert the above date to 28/2/2020(dd/mm/yyyy).

In addition to this i need to add one month(i.e edate to the above date format(28/2/2020(dd/mm/yyyy).

I have in cells DK2 the following date:- 28/02/2020 . i need to increase cells DK2 to one month to cells DK84.

Your help will be highly appreciated

thanks/regards

rakesh

 

[bjorn1404]

Hey Rakesh,

=date()+30 will make it one month further
than you can change tot format to(dd-mm-yyyy)

 

[rakesh seebaruth]

Thanks will try it