Somproduct

**Selo** · 03-01-2008, 10:21 AM

Hello
how can i change this formula so it also looks for the year?
=SOMPRODUCT(--(TEKST(Overige!$B$2:$B$1445;"mmmm")=A58))

**VBA Noob** · 03-01-2008, 11:26 AM

"mmmm"

Returns the month. To return a year as well you can use

"mmmmyy"

e.g March08.

"mmmm-yy"

e.g March-08.

"mmmmyyyy"

e.g March2008.

etc

VBA Noob

**Selo** · 03-02-2008, 07:53 PM

thank you

Is this possible with
cel A1 contains a date lets says 01-02-08 (dd-mm-yy)
B1 contains 05-03-08

I wan ta formule that only looks between those dates

**daddylonglegs** · 03-02-2008, 08:12 PM

Try

=SOMPRODUCT((Overige!$B$2:$B$1445>=A1)*(Overige!$B$2:$B$1445<=B1))

**Selo** · 03-05-2008, 08:13 PM

Thank you and sorry for my late response i am going to try those forumlas out thanks

Somproduct

LinkBack

Thread Tools

Rate This Thread

Display

Somproduct

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions