This sounds like a simple one by the thread description but it's got me scratching my head.
I've got a rota where in E1 I enter the date that the week starts (our week starts on a Monday) with the cell format set to Date - 14 March 2001 format.
In row 2 I then have the days of the week in the cells of row 2 which I've simplyt added as text i.e. B2=Mon, D2=Tue, F2=Wed up to L2=Sat.
What I would like is that when I enter the week commencing date in E1 it automatically updates B2, D2, F2 etc so that they then display Mon 24, Tue 25, Wed 26 etc
Ideally I'd really like it if it added th, st & nd to the dates i.e. 21st, 2nd, 5th but that's not essential.
Is this possible?
Hi all
I have a list of 'dates' shown as a number, ie 39850 is today 6th Feb
this list is shown through Column A of sheet3 and in column B I would like the corresponding day for that date, so
Column A shows 39850 Column B would show FRI
thanks in advance
I need to draw a graph with 2D line type. It seems that Excel only allows to show dates (x-coordinate) by day, month or year. But based on my resource data, I really wish to show dates by week. Is there a way to make it???
Thanks for your help!
Hi, I have a list of dates from someone who sent me some e-mails from 05/08/2006 to 09/06/2008.
Those dates are placed in A1 to A176.
I would like the program to tell me how many times a week the date is there.
Because I need to make a statistic graph telling me how many times a week I was receiving a message from that particular person.
I have attached the Excel spreadsheet.
Thank you very much for your help !
ATH500
If I have a range of dates in column A (i.e., 3 different dates in this
column: 7/1/06, 7/5/06, and 7/9/06), I want to format cells in column B to
show the week-ending date (Sunday) for each particular dates from column A.
For example, if column A has 6/29/06 date (Friday), column B should show the
week-ending date for that week as 7/2/06 (Sunday). Please advise! Thanks!
I use the following formula on a spreadsheet to show the Sunday date of a particular week number:
The week number from 1-52 is entered into cell C38
Cell 39 shows the date from this formula "=(7*C38)+DATE(YEAR(NOW()),1,1)-9"
This returns the date I am looking for
How can I put this onto a user form?
For example Text Box 1 contains the week number from 1-52
And Text Box 2 would show the corresponding Sunday date.
Afternoon all,
just wanted a few general tips and a point in the right direction for what i'd have to do to achieve the following.
I have 13 sheets, Jan - Dec then a Summary page. Each sheet shows sales figures for approx 500 stores. The summary page just adds these up for a YTD total - simples. To make things a bit 'sexier' i'd like to double click a value in my summary page and a graph to pop up with the trend for the year, so a bar graph with each months figures. I have a particular format of chart to use (pilfered from a colleagues worksheet!).
Whats the general gist. Would i be talking about a userform pop up for each one? Is this something which is just done through coding or some other bells and whistles needed?
Much appreciated.
CDH
Is there a way to show a single letter for the day of week in an excel chart (i.e. change "Mon" to "M")? I know if you do "mmmmm" for month you get the single letter for the month but I can't find anything for the day of week. Thanks in advance for any comments.
Hi Excel Users,
I'm seeking a formula that will always show Monday's Date (Week Beginning) or Sunday's Date (Week Ending).
For Example, if I want Week Beginning & have a date of 10/20/10, a formula in another cell would display 10/18/10 - Monday's Date.
Or Vice Versa,
If I want Week Ending & have a date of 10/20/10, a formula in another cell would display 10/24/10 - Sunday's Date
Thanks
Some of my colleagues don't have MS Project (MSP), so I have been pasting MSP data/columns into excel so that:
Column A = Activity
Column B = %age Complete
Column C = Start Date
Column D = End Date
I then introduced a number of columns to the right of the sheet to represent sequential weeks across the year e.g. week commencing 02-Nov; 09-Nov; 16;Nov etc.
With the objective of the relevant weeks to be shaded if the dates in column's C and D fall into that week activity e.g. Start date = 1st Sept and End Date = 18th Sept then the appropriate 3 weeks columns on the right of the spreadsheet get shaded grey.
Using formula : =IF(AND($C2=O$1)," ","") So the conditional formatting is triggered by the space (" ")
BUT!! My problem is where the date in column c = the date in column D (i.e. a milestone in terms of MSP) the week in which that milestone falls does not get shaded in. HELP!!
I have done an example but can't work out how to paste it in!
