Converting sequence of days into number of days

J

joel claes

Hi all
I wonder how I could easily translate the following...
Month Days
Apr-04 123_567
May-04 1234___

Considering that Apr-04 has 4 Mondays, 4 Tuesdays, ...
I would like to know that 123_567 for Apr-04 counts 25 days
or 1234___ for May-04 counts 17 days

Is that possible with Excel functions ?

Thanks for all help

Joël
 
D

Daniel.M

Hi Joel,

With:
A1: Your date (1st of the month)
B1: The Days 'pattern' ("12_45")

=SUMPRODUCT(--ISNUMBER(SEARCH(WEEKDAY(ROW(INDIRECT(
A1&":"&DATE(YEAR(A1),MONTH(A1)+1,0))),2),B1)))

Regards,

Daniel M.

Hi all
I wonder how I could easily translate the following...
Month Days
Apr-04 123_567
May-04 1234___

Considering that Apr-04 has 4 Mondays, 4 Tuesdays, ...
I would like to know that 123_567 for Apr-04 counts 25 days
or 1234___ for May-04 counts 17 days

Is that possible with Excel functions ?

Thanks for all help

Joël
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top