Help with #value! error

[Madrizmoreno]

Hi, can someone help with this error in excel. My formula is IF(WEEKDAY(DATEVALUE(MoMonth&" 1, "&MoYear))=COLUMN(B$2),1,IF(LEN(A6)>0,A6+1,"")) but cannot manage to solve it by meself.

Its a week planner that adds the correct date and corresponding task to the day.

Any help is much appreciated. Thanks.

 

[Jonmo1]

I think it's the regional settings, you're using UK dates right?

This part DATEVALUE(MoMonth&" 1, "&MoYear)
The date format this is creating is
mmmm d, yyyy

I think that's not working in UK date formats.

Try changing this to a d mmmm yyyy arrangement instead
DATEVALUE("1 "&MoMonth &" "&MoYear)

This works for either US or UK regional settings.