0
Date Formula?
I need a formaula to claculate 30 days from end of month, but struggling to find a formula that calculates how to add 30 days to the end of an existing month, any suggestions?
2 replies
-
Find the last day of the current month with this formula:
---
let myDay := today();
date(year(myDay), month(myDay) + 1, 1) - 1---
So, in your case try this (last day of the current month + 30):
---
let myDay := today();
date(year(myDay), month(myDay) + 1, 1) - 1 + 30---
-
Perfecto, thanks Nick much appreacited. I just couldnt find anything on the manual or any post! Top man!
Content aside
- 4 yrs agoLast active
- 2Replies
- 761Views