Date with text formula.

[srizki]

Hi all,

I have the following formula in column “U”,

'=IF(I37="","",IF(I37="BIL",LEFT($U$8,4)&" JIB",IF(I37="NON",LEFT($U$8,4)&" REV")))

I want to update it so that instead of, LEFT($U$8,4)&" REV"))) it should read the date from column, “M”, and take the previous month, so if the date is 02/28/2018, it should take the date and the result should be, “0118 REV”, something like,

=IF(I2="NON",TEXT(DATE(M2,MONTH(M2-1),"MMYY")&" REV",""))

Thanks

 

[Melvin88]

Try using the Text("Cell with date", "MMDDYY") function. That will return what you're looking for.

 

[njimack]

Try: TEXT(EDATE(M2,-1),"MMYY")

 

[srizki]

Yes, it is working as I wanted.
Cheers,

 

[srizki]

Thanks Melvin.