Records for the curren week

[Catalina]

I use this to count the records that have been entered today:

=DCount("*","tblPeople","PE_Added = #" & Date() & "#")

Now I want to count the records entered in the current week.
Tried some suggestions I found here and there such as:

?DCount("*","tblPeople","[PE_Added]>=" & Format(DateAdd("d",1-Weekday(Date()),Date()),"#mm\/dd\/yyyy#"))

Can't get it to work, it keeps giving me errors.

All help will be greatly appreciated.

Catalina

 

[Catalina]

I think I just found the answer:

=DCount("*","[tblPeople]","DateAdd('ww', 0, [PE_Added]) Between Date() And DateAdd('d', -6, Date())")

Catalina