• We’re currently investigating an issue related to the forum theme and styling that is impacting page layout and visual formatting. The problem has been identified, and we are actively working on a resolution. There is no impact to user data or functionality, this is strictly a front-end display issue. We’ll post an update once the fix has been deployed. Thanks for your patience while we get this sorted.

SOLVED - Excel Syntax Question

C

Caveman

Platinum Member
I need to create a matrix of data. Each cell in the top row of data represents a week timespan, so I want that to be displayed in each cell (i.e. May25 in the cell implies: the week of May 25-May31).

Also I want each cell to be keyed off of any date a user enters in the 1st cell field to be indexed by 1 for each sucessive cell. For instance, if a user keys in a date such as 1June, (any format is ok), then the diplayed Date headers would look like this:

A1 A2 A3 A4 Etc...
1Jun 8Jun 15Jun 22Jun 29Jun

Each date for each cell header would be 1 week apart.

Anyone know how to do this?

Turned out to be easy...
 
Yup... Format all the cells in the date format of your choice, them Map in the formula as above to just add 7 days to the original date... Hope someone else was helped...

This is a great forum.
 
Ah thanks, I also hope that helped someone else. It's good to post solutions even to your own problems so others can learn.
 
You must log in or register to reply here.

TRENDING THREADS

Back
Top