Excel Formula to find date

[kondkarimoshin]

Hi All,

Need a urgent help : Need excel formula for the below three condition.

I have two column A & B

CritDate and Value :

if the if CritDate deliveries in current week the Value = text "CDCM /DCW"

if critical date deliveries is in current month then Value = text "CDCM"

Critical date issues in next month then Value = text "CDNM"

Please friends urgent help needed

 

[kondkarimoshin]

If you see the deliveries is in current week then it should be kipping the Current month value coz by default we writing it in Current week. : CDCM/DCW
DCW : deliveries in current week
CDCM: deliveries is in current month
CDNM : Critical date issues in next month