Check if a given date falls on first week of current month

[Junarkar]

Hai

I want to check if a given date falls on 1st week of the current month. The week starts from Monday. I tried combinations of EOMONTH, WeekDay etc. but nothing works.

Please help.

Thanks.

 

[GraH - Guido]

Try (date is in A3 e.g.)
=WEEKNUM(A3,21)=WEEKNUM(EOMONTH(A3,-1)+1,21)

WEEKNUM(A3,21)= returns ISO weeknum (EU standard), but for this formula it does not really matter, it can be omitted.

 

[Junarkar]

Try (date is in A3 e.g.)
=WEEKNUM(A3,21)=WEEKNUM(EOMONTH(A3,-1)+1,21)

WEEKNUM(A3,21)= returns ISO weeknum (EU standard), but for this formula it does not really matter, it can be omitted.

Thanks Alot. That served my purpose.