Convert weekno to a date
I have a week no. (say week 2) in cell A4 and I want to convert that
to the Fiday of that week (in cell B7) in the format Fri 14th Jan 2005.
Could anybody tell me how to achieve this please.
See if this is something you can work with:
A4: 2 (The week number)
A5: 2005 (The year..you didn't mention if the formula might apply to other
Does that help?
> I have a week no. (say week 2) in cell A4 and I want to convert that
> to the Fiday of that week ...Any word on CRM 1.2 release date?
Has anyone heard a firm release date yet for CRM version 1.2?
And will CRM 1.2 work with SBS2003 that was just released?
"Jim" <firstname.lastname@example.org> wrote in message
> Has anyone heard a firm release date yet for CRM version 1.2?
This depends on where you are based. I've just got home
from an MS course, and we told that in Australia it will
release to the partners at the conference late next month,
and will be released to customers on 12/1/04.
It was also confirmed that it will run on SBS2003 - it
will ru...need Help for Migration Exchange 5.5
we`ve the following Configuration :
- Exchange 5.5 with SP4
- single Winwos 2000 DC
- configured both side ADC
a new Hardware should be used for an Exchange 2003 and second DC.
next steps i would do as following :
- Update ADC Version with Exchange 2003 ADC
- running Exchange 2003 forestprep, then domainprep, an after all
running setup to install Exchange 2003 in the same organization, site
- replicate system Folders and public Folders
- moving all Mailboxes to the Exchange 2003 Store
- configure the Exchange 2003 virtual SMTP Server to send outgoing
- reconfigure the F...date problem #10
Thanks a lot, Dave
This piece of code works great.
M P Redd
mpreddy's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1327
View this thread: http://www.excelforum.com/showthread.php?threadid=26358
...Need help to read Pie Chart Series Range
Excel 2003, I have an existing Pie Chart and want to extract the Ranges
My code below returns with a "Type mismatch" error.
Dim mySeries As Series
Set mySeries = ActiveChart.SeriesCollection(1)
Debug.Print mySeries.XValues (errors here)
...Word Doc Macro help needed please!
I need to make a mocro that will work in a word doc. This macro would
start with  and count up one number each paragraph. For example
paragraph two would auto show  and so on. Any help would be
I have a word file which contains 100 pages. All the pages have name &
address of companies.(not in table) i have to transfer them to excel in
column format(for example first name, last name, address, phone etc)
can any one tell me code for this( i know how to open word & creat new
excel sheet) . I need code for how to reach to lines of word. r there
any thing like &quo...Printing changes layout
I am printing a booklet on Pub 2002 - when I print one page, it prints a page
where everything has changed - resized, cut off the edges, etc. The worst
part - when done printing, it goes back to normal view and it actually
changes my layout to match what is printed - permanently.
Any ideas what is going on? I printed on both my Lexmark and HP printers,
does the same thing. I have Windows XP.
Look at your page layout, has it changed? I know this will happen to me
occasionally when I change printers. If I change back to the original printer
the publication will revert...copy date in a cell if within a date range
Column M is a listing of percentages
Column A is various dates, anywhere from Jan 1, 1998 to the present.
I need to copy the contents of let's say M3 into cell T3 is the date in cell
A3 is any date in the year 2010. If the date is in another year, leave cell
> Column M is a listing of percentages
> Column A is various dates, anywhere from Jan 1, 1998 to the present.
> I need to copy the contents of let's say M3 into cell T3 is the date in cell
> A3 is any date in the year 2010. If the ...Help With Sorting #3
Gudday to all XL gurus.
I need some help on using the SORT function.
I have a list of 100 competitors in a scoring spreadsheet that I hav
I was trying to sort by surname (a-z). The problem is that this list i
generated elsewhere and contains VLOOKUP functions. Obviously if i hav
less than 100 competitors I end up with some cells appear blank bu
contain VLOOKUP functions. XL sorts them first and I want them sorte
last after the surnames (a-z). I cant add a helper column as this lis
relates to over 48,000 forumulaes and functions that are already added
If I add a helper column I have...Need help converting Microsoft Outlook calendar to Entourage.... At wits' end here! Please advise...
I have a Mac at work which runs Microsoft Outlook 2001 client on an Exchange
server. I have a calendar on this machine (stored locally, not on the
server) which has a ton of reminders programmed into it - very useful! Now,
at home I got a new Mac laptop with Entourage X. Is there any way to move
all of the reminders (appointments) from my calendar on Outlook to my
Entourage calendar? I've tried two things:
1) I exported the calendar info as a CSV text file, and then tried importing
it in Entourage. The problem is that Entourage import function seems to
think it's importing an Address...Bill Summary skips Apay due dates
I know I saw something about this some time ago but I can't find the info
Microsoft Money 2007 Deluxe
Bank - Wachovia
I have 2 monthly Apays that I set up on Wachovia's website which were
downloaded into Money's Bill Summary. I looked today and, though the next
payment that hadn't posted to the register should be due 10/20/2008 the Due
Date showing in Bill Summary was 3/20/2009.
I've canceled the Apays and re-created them but I know this is a chronic
issue. I already went through the full file repair process a while ago and
...help with lookup formula (sheet 2, not a double post)
I need to make a formula using a lookup. The first spreadsheet is a
inventory (ALO INVENTORY JP). The second (P&G 103) is a chart tha
tells number of gallons of alcohol per foot/inch/fraction.
On ALO INVENTORY JP I insert the # of feet, inches, and the fraction i
cells R5 and T5. I want these numbers to lookup the number of gallon
off of the P&G 103 worksheet.
For example: P&G 103 (on inventory sheet) is 26ft 4 1/2 inches, i
should look-up to be 34572 gal. for the 26'4" and 55 gal. for the 1/2"
These two numbers should be added together and multiplied by the numbe
...Help!! Way to find users sending email to large amount of receipients.
Could some one tell me if there is a way in Exchange 2003
to find out what users are sending email to a large
amount of recipients?
I'm having some serious performance issues and I'm sure
it's some one sending email to a large amount of
I have a problem. I have a list of numbers that are in one column.
Alot of numbers 8000 or so, and I need to find if there are an
duplicates. I sort them so that they are in order, but having t
scroll through the whole list takes alot of time and hurts my eyes!!
I tried advanced filter but I can only find how to find duplicates in
Someone help me please!
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
~~Now Available: Financial Statements.xls, a step...Help with displaying the contents of the last populate cell.
I have numerous sheets within a book where all cells in column C in all
sheets have the following formula “=IF(ISBLANK(P4),"",(R3-P4))”. For you
reference both columns P and R hold a monetary value and are formatted as
Is there a way that cell D1 can automatically be populated with the contents
of the last cell in column C that has a value in it.
Sheet 1, cell C19 has a value of 200, therefore cell D1 should be 200.
Sheet 2, cell C25 has a value of 250, therefore cell D1 should be 250.
Sheet 3, cell C99 has a value of 900, therefore cell D1 should be 900.
Any h...Help on filter
I have a list to filter. I have to keep only integers.
I tried everything in advanced filters... does not work.
Can you help me please?
Message posted from http://www.ExcelForum.com
one way: use a helper column. Lets say your numbers are in column A
then enter the following formula in an adjacent cell for row 2
copy this down for all rows. After this filter with this helper column
> I have a list to filter. I have to keep only integers.
> I tried everything in ...help!
I have been given a dataset with data,but the problem is now i need to
create membership cards,which i plan to use the label wizard in reports,but i
also have to display the intials of the customer but i have not been given
the fields for intials just forename and last name.Is there maybe a way of
running a query to search for some of the forename field to use as my
I thought I had seen this post a day or two ago and it was answered.
If you want Initial and Last name
Left(FirstName,1) & " " & LastName
Dave Hargis, Microsoft Access MVP
&qu...Pointing to correct macro path using excel custom toolbar
I have created an excel 2000 template (.xlt) containing a number o
macros. When I open copies of this template on various pcs, the macro
function correctly, except I cannot successfully run the macros usin
the custom toolbar I created, because (I think) within the toolbar th
paths to the macros are pointed to the original location on my pc. An
advice on how I can resolve this would be gratefully received
Message posted from http://www.ExcelForum.com
Have you thought about building the toolbar when the file opens?
Or maybe separating the worksheet portion of the template from the code pa...Lookups across worksheets
I need to consolidate some information, using several worksheets in one
file. Here's an idea of what I need to do:
WORKSHEET 1 - [/B]
BILL | SMITH | 1 | 3
JEN | JONES | 2 | 1
[B]WORKSHEET 2 -
1 | Acme
2 | Widgets
3 | Bucky's
WORKSHEET 3 -
1 | New York
2 | Paris
3 | Rome
I need to come up with a set of formulas that give me the following
WORKSHEET 1 -
_F...Date Problem #2
Please can someone advise me what to do, I have a date in a textbox where I
am using the AddDate method to increment the day , but I am getting strange
Is this because the US date? if so how do I change this to work for the UK
Any help would be greatly appreciated
i'm not sure what formula you're using-
I put a random date in A1 and pasted the following formula in B1 & C1:
it increased the day by 1 in both cells.
I then changed the format to UK and it worked just fine.
Is this what you're l...Hide row code help
I am using the following script to hide or unhide rows. How do I code the
offset to only work when a row is being unhid. If we cant do this only
offset when it is being hidden or unhidden?
Private Sub Worksheet_Change(ByVal Target As Range)
'Application.EnableEvents = False' not necessary
If Not Application.Intersect(Target, Range("B9")) Is Nothing Then
Rows("10:11").Hidden = IIf(UCase(Range("B9")) = "", True, False) 'spelling
'Application.EnableEvents = False
...Text to Date
I have been given a database dump (thousands of rows) that put the dates in a
text format like this:
Is there any way to put this into a date format? Even if it means creating a
new field breaking it up and doing some extra steps.
Change to appropriate cell reference:
"PAL" <PAL@discussions.microsoft.com> wrote in message
>I have been given a database dump (thousands of rows) that put the da...Expiration Date on Trial Period
Is there a way to determine what the expiration date of a trial period
Thanks for posting in. This is Ken in Online Partner Support.
The trial program will be expired in 90 days from installation date so why
don't you confirm the installation date?
If you use Windows Server 2008, you are able to confirm the date from
Programs and Features and if you use Windows Server 2003, how about check
the create date of install folder?
Microsoft Online Partne...Help with macro/and or formula?
Perhaps this is a silly question, but i just can't figure out how t
format this worksheet. The problem is that a lot of the cells hav
numbers in them with negative signs in the back instead of in the fron
(ie. 23-) and i was wondering if anyone knew of a macro/formula i coul
use to quickly fix this problem for all the cells. I would b
extremely grateful. Thanks
brefed15's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=3557
View this thread: http://www.excelforum.com/showthre...help when bills are automatically debited from my bank
I had and tried Money 2002. I entered my data about a
dozen times. Things "looked" great, but the program
never quite worked for me, partic. with respect to
reconciling/balancing my account. I heard Money 2004
made things much easier, so I bought that but I am having
the same problems. I think it might have to do with how
my bill payments are set up and how I enter those
transaction into Money when I first provide the info:
I do online banking with Citibank. Since Money and
Citibank don't have the automatic connection, I have to
download statements from Citibank in...