DATE
HI, i need to calculate -2 month for a date (eg. 1/10/2018). Now i tried with in the other i used
CONCATENATE(“1/”,MONTH([Invoice Datel] -3),"/",YEAR([Invoice Date]))
The problem is for gen and feb, because the system maybe couldn’t
calculate 1(Gen) - 2(Oct)
How can i resolve it?
+Steve Coile @Aleksi_Alkio
I Tried also
CONCATENATE(“1/”,MONTH(TODAY() -60)-1,"/",YEAR(TODAY() -60))
Last day of this month:
EOMONTH(TODAY(), 0)
Last day of next month:
EOMONTH(TODAY(), 1)
Last day of last month:
EOMONTH(TODAY(), -1)
First day of next month:
EOMONTH(TODAY(), 0) + 1
First day of this month:
EOMONTH(TODAY(), -1) + 1
First day of last month:
EOMONTH(TODAY(), -2) + 1
One month from today:
EOMONTH(TODAY(), 0) + DAY(TODAY())
Today:
EOMONTH(TODAY(), -1) + DAY(TODAY())
One month ago:
EOMONTH(TODAY(), -2) + DAY(TODAY())
+Steve Coile Tx, it works
Great examples Steve! Commenting so I can find this later.
User | Count |
---|---|
61 | |
25 | |
14 | |
11 | |
6 |