Calculated Column Support

Copper Contributor

Hello All - I have a SP List in which one of the Drp downs is Month. The month has been mentioned in following way."Jul-23, Aug-23," and so on.

 

When I write a formula in calculated column to get the complete date, the date comes up as 7/23/2024. My current formula is =DATE(YEAR(Month),MONTH(Month)-11,0). but when Jan 24 is entered, it take this as 1/31/2023. how can I manage this?

0 Replies