DATE HI, i need to calculate -2 month for a...

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

0 4 448
4 REPLIES 4

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.

Top Labels in this Space