I need to label dates according to the current date.

**Alistairm88** · 01-08-2016, 10:29 AM

Hello.

I have been racking my brains for a while now trying to find a solution. Basically I have a set of data with 20 days worth of information displayed in columns. The data is refreshed everyday so will shift by one column each day. I need a way of labelling each column according to which day it is today by inserting an extra row on top.

I.e - If the first column of data is Tuesday 08/01/2016, I want it to be labelled 'Current Week', until Saturday, when I want to be labelled 'Current Week Plus 1' instead. And then next Saturday be labelled 'Current Week +2" and so on.

Any ideas of how to do this?

Thanks in advance

**zbor** · 01-08-2016, 10:37 AM

Here, try this:

Formula:

Please Login or Register  to view this content.

You might want to adopt WEEKNUM to match your first day of week as:
WEEKNUM(serial_number,[return_type])

Where return_type is:

Please Login or Register  to view this content.

**Alistairm88** · 01-08-2016, 10:51 AM

Many thanks for your quick response!! Makes total sense and is kinda obvious now I've used it! Thanks again

**Alistairm88** · 01-08-2016, 10:54 AM

And how do I change it so that Saturday is first day? Do I enter that into the formula?

**zbor** · 01-08-2016, 10:56 AM

Yes.
In all WEEKNUM formula change for example:
WEEKNUM(A2)
into
WEEKNUM(A2, 16)

Spred it over two weeks and then you will see does it match.
If not change 16 based on above table into some other number till you get desired output.

**Alistairm88** · 01-08-2016, 10:58 AM

Whoop thanks again

**Alistairm88** · 01-08-2016, 11:18 AM

Hi

I have another question, I have now labelled all of the columns, but now need to get the sum of each row where the columns equal' Current Week', then "Current Week plus 1", etc.

Would you know how best to do this?

**zbor** · 01-08-2016, 11:19 AM

A SUMIF formula will do but attach example workbook for more details.

**Alistairm88** · 01-08-2016, 11:28 AM

example.xlsx

Hi

Please see attached - the yellow cells need a formula to get the correct values manually typed in.

Thanks

**zbor** · 01-08-2016, 11:35 AM

Here.
You just need to have same headers as criteria to match.
I've also adopt previous issue with week numbers.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Thanks.

I need to label dates according to the current date.

LinkBack

Thread Tools

Rate This Thread

Display

I need to label dates according to the current date.

Re: I need to label dates according to the current date.

Re: I need to label dates according to the current date.

Re: I need to label dates according to the current date.

Re: I need to label dates according to the current date.

Re: I need to label dates according to the current date.

Re: I need to label dates according to the current date.

Re: I need to label dates according to the current date.

Re: I need to label dates according to the current date.

Re: I need to label dates according to the current date.

Thread Information

Users Browsing this Thread

Similar Threads

sum costs to date & return current dates

UserForm label to show current date

[SOLVED] Filter dates according to current date

Hide all dates in pivot table and select current date and othes six passed dates

Label to display current Date, Time

[SOLVED] How do I get the most current date from a list of dates?

Calculating dates based on the current date

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions