WeekStart question

[alexpanjhc]

I have a file where it shows all the counts for the invoices everyday. I want to show them by a date ---that is every monday of the week ,

so I used weekstart(date) to show the week.

The issue is March 1 is a Friday, when I used weekstart(date), it will skip march 1st and the count will be less.

How to add march 1 back to my chart?

Thanks!

[swuehl]

Not sure if I understood correctly, I think Mar 1st will still be counted, but towards its February weekstart.

Can you maybe explain with some sample data lines how your input data looks like and how you want to display it?

[alexpanjhc]

Hi thaks for replying

The attached is the date file.

So if I start using weekdate, the march 1 does not show instead 2/25.

I do not want to see 2/25.

Actually for each month, they'd like to see the actual date not the forwading weekstart

Is this doable?

Thanks!

[swuehl]

Are you thinking of something like attached?

Try

=if(Month(weekstart(F1))=month(F1),Weekstart(F1))

as calculated dimension and suppress NULL on the dimension.

This will supress your week starting in February, but please note that your last week is also not a complete week, so comparing this week with the other, full 7 days weeks, is like comparing apples with oranges.

[alexpanjhc]

Thanks,

But I still need march 1 show on the chart.

[swuehl]

I'm still unsure what you want to show with this kind of chart, but try

=if(Month(weekstart(F1))=month(F1),Weekstart(F1), monthstart(F1) )