How can I display a date range based on week/month numbers?

Joshua Fargason

 

Here's the situation:

I have a bar chart on a dashboard that displays the dollar value of bids submitted by week going back the last five weeks and another for the last five months to help the estimating team track where we are on meeting goals.  At the moment the labels under the bars are Last Week, 2 Weeks Ago, etc. because I do not know if it's possible to code a cell to turn out a date range based on a week number or a month name based on a month number.  

Is this possible?  How would I code that in?

Thanks!

Joshua Fargason

Ok, discovered a way to display long form month names here, just in case anyone is looking for the same thing later: 

https://community.smartsheet.com/discussion/how-convert-dates-long-form-date-format

 

Paul Newcome

There are easier ways of doing it using tables and INDEX/MATCH vs using long nested IF statements. It is more flexible and MUCH less susceptible to a typo or missed parenthesis. This can be used for both long form month names and date ranges for a weekly breakdown. A little tweaking would also provide the year for the month names.

 

If you are interested, let me know. I'd be more than happy to help.