How to get the last day of the previous month in pabbly?
Status: Closed · Asked by Lucas. on · 0 views
Looking for the best way to show the last day of the previous month in pabbly?
Excel formula is not working in pabbly
=EOMONTH(2022-09-01,-1)
Hey @Lucas.
You can refer to the following screenshot for your work.
@Supreme, thanks for your reply but the last day of the previous month is 2022-08-31.
This is dependant on the month. September will end 2022-09-30 and february 2023-02-28.
Hey @Lucas.
You can google for another formula for the Spreadsheet or can you use the regular expression for the same which you can use in the Text Formatter by Pabbly : Extract Pattern action step.
Tried looking, but there is no other formula to find the last day of the month then =EOMONTH(A2,0)
What do you mean by regular expression?
Solved this by putting the formula in Google Sheets and getting the result in a next step.
[TABLE]
[TR]
[TD]Today[/TD]
[TD]END OF MONTH[/TD]
[TD]FIRST DAY OF MONTH[/TD]
[/TR]
[TR]
[TD]=TODAY()[/TD]
[TD]=EOMONTH(A1;0)[/TD]
[TD]=EOMONTH(A1;-1)+1 [/TD]
[/TR]
[/TABLE]