ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   how do i put dates into workweek buckets in excel (https://www.excelbanter.com/excel-discussion-misc-queries/153418-how-do-i-put-dates-into-workweek-buckets-excel.html)

ricardomanet

how do i put dates into workweek buckets in excel
 
Hi
I data that were detected in several days of the year, but i want to
simplify the data by arranging them under work weeks so i can have simple
charts. any help will be appreciated. Also if a VBA code can be generated
that would be nice

Richard

Toppers

how do i put dates into workweek buckets in excel
 
Look at WEEKNUM function.

"ricardomanet" wrote:

Hi
I data that were detected in several days of the year, but i want to
simplify the data by arranging them under work weeks so i can have simple
charts. any help will be appreciated. Also if a VBA code can be generated
that would be nice

Richard



All times are GMT +1. The time now is 03:22 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com