Count Week number from range of dates

**nagesh.tvsr** · 10-24-2018, 08:32 AM

Hi,

Need help in Counting the data of week number from list of dates.

Excel file attached with necessary info.

Pl. help.

Thanks,
Nagesh.

**kersplash** · 10-24-2018, 08:55 AM

For your sample can you show what the actual results should be in the highlighted cells?

**Bo_Ry** · 10-24-2018, 09:31 AM

Please see attached,

Countifs without helper columns

C3

Formula:

Please Login or Register  to view this content.

D3

Formula:

Please Login or Register  to view this content.

C4

Formula:

Please Login or Register  to view this content.

D4

Formula:

Please Login or Register  to view this content.

Countifs with helper columns

E3

Formula:

Please Login or Register  to view this content.

F3

Formula:

Please Login or Register  to view this content.

E4

Formula:

Please Login or Register  to view this content.

F4

Formula:

Please Login or Register  to view this content.

Sorry, Ali
Formula added

**nagesh.tvsr** · 10-24-2018, 11:42 PM

Thank you very much Bo. Its working wonderful.

Nagesh.

Re: Count Week number from range of dates