I realy need some help with an Excel problem that has stumped me for the last two days!
In Column A I have the whole years dates listed(01/01/2007..etc.), in column b the day(Monday..etc.)In Column C sales figures(21, 20, etc.) up to date completed.
Now in a cell below I would like to count how many days in a range(All January dates in column A) have a spesific day (Let's use Monday) and also have some sales figures in Column C (Non Blank).
This will then indicate (count) in the cell below how many Mondays in January have completed sales figures. In short (How many Mondays work completed in January!)
Please can anyone help with this?
Kind regards
Jacques
Bookmarks