Date formula

[Prajwal19]

Hi,

I have dates in column A, I want know a formual wherein if the dates are in 2019 then the output should be 2019. If the dates are in 2020 then the output should be their respective month. 

[BrianR · Accepted solution]

Hi @Prajwal19, you can place a Formula tool right after your data, and then you can transform it with this Formula:

[vizAlter · Accepted solution]

Hi @Prajwal19 —  Try this solution too... you can achieve the result without using a Formula tool as well:

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution.  Thank you.