Converting sequence of days into number of days

  • Thread starter Thread starter joel claes
  • Start date Start date
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
 
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
 
Back
Top