-2

I want to display always the last day of the previous month.

So for example, right now it should display: 28.2.2021

Thanks in Advance!

Oliver Eckerstorfer
  • 1

1 Answers1

0

You could use this formula in calculated column:

=DATE(YEAR(NOW()),MONTH(NOW()),0)

enter image description here

Michael Han
  • 3,475
  • 1
  • 6
  • 8