Associating Data with a Calendar Week

[Ute4Life]

I have data arrayed in a spreadsheet, with individual orders in rows, and order dates (daily) and revenue in columns. I need to associate the daily orders and revenue with the calendar weeks (by number), where Week 1 is Jan4 - Jan10, Week 2 is Jan11 - Jan16, and so on. I would like to see, by Week #, how many and how much revenue is associated with the orders. Is there a function in Excel to accomplish this?

 

[Kelbo]

Welcome to the board.

You can use the formula:

=WEEKNUM(F1,1)-1 where your date is in cell F1

The 1 after the comma in the brackets is for weeks beginning Sunday.
Use 2 for week start Monday.

Microsoft start the weeknumbers from the 1st of Jan, so for your weeks the last '-1' corrects to your needs.

Kelbo

 

[Ute4Life]

Thanks. That worked after I loaded the Analysis ToolPak Add-In from the Tools menu.