Hi there! How can I create an initiail value...

(Aparicio Piñeyrúa) #1

Hi there!

How can I create an initiail value that show allways the first day of the month?

Eg: 01/01/2018

Thanks!

(Aleksi Alkio) #2

How about CONCATENATE(MONTH(TODAY()),"/1/",YEAR(TODAY()))