Forum Discussion

paris's avatar
paris
Icon for Helper V rankHelper V
6 years ago
Solved

If with < formula

Hi All,   Please help. For some reason, my date switch month and year every 13th of each month and back again at the begining of month.    correct month=If ([Month]<12,[Day],[Month])    This do...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    6 years ago

    hi  paris 

    Just try this simple formula

    CorrectDay = IF([Day]>12,[Day],[Month])
    CorrectMonth = IF([Day]>12,[Month],[Day])

    Result:

     

    Regards,

    Lin

paris's avatar
paris
Icon for Helper V rankHelper V
6 years ago

Hallo Amitchandak,

 

I am sorry I was not clear.

Date is in text format. When I used formular to get day and month, I got them wrong so I want to correct like yellow here.

 

 

All the best,

Paris