Date extract

Question

day  month
25   feb/march
26   feb/march
27  feb/march
28   feb/march
29  feb/march
1   feb/march
2   feb/march
3   feb/march

required output

date
25 feb
26 feb
27 feb
28 feb
29 feb
1 march
2 march
3 march

Can anyone help me with this please

suraj46nair · Answer

use formula tool -

IF [Day]<25 THEN 'march'
ELSEIF [Day]>=25 THEN 'feb' ELSE '' ENDIF

binu_acs · Answer

@Saifshaikh026 What is the logic applied to get the desired result?