How to find last day of the month?

Community Discussions
,
1

How to find last day of the month for given date? L

Thanks

San

2

Hi @San! How about a formula like this?
=DATE(YEAR(THISROW()[Date]),MONTH(THISROW()[Date])+1,1)-1

You can set an entire column format as that as well:

2020-11-07_19-51-26 (1)
2020-11-07_19-51-26 (1)1126×708 905 KB

1 Like
3

Perfect! Thanks AJ!

4

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.