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" <email@example.com> 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...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
...autofit: cell height expands with text entered?
For a form:
can a user enter mass quantities of text in a cell and
have the cell depth expand so it fits?
does Merging Cells limit this ability? I made a giant cell
to handle the text the user might enter.
I can't figure out where to set this...
I have copied & pasted formatting from one worksheet to
another without luck.
Merged cells don't adjust rowheight for wrapped text (like non-merged cells do).
Jim Rech wrote a macro called AutoFitMergedCellRowHeight that you may like:
Sandy wrote:...Go To the next empty cell in Column A
Using Vista and Excel 2007, I will be constructing a mailing list with 10
columns. In the first empty row of column A will be added a new name for the
list. With 10 columns it is not possible to view Column A from Column L on
screen. With hundreds of names to add to the list, I need a fast way to go
to the next empty cell in column A to add the next name..
I am familiar with tables in Access where there is an icon that will take me
to the next empty cell in column A. Is there a similar one stroke command to
take me to the next empty cell in column A from anywhere in an Excel
...User defined functions aware of what cell they are placed in?
I would like to make a user defined function which needs to know in
what cell and what worksheet it is placed in. I will be using this UDF
in multiple cells on multiple worksheets. I originally just passed the
cell row and column as parameters to the UDF however this ended up
updating all worksheets and not just the one the UDF was on.
Is there any way to do this?
function myfunct(something as somethingelse) as something
msgbox application.caller.address & vblf _
& application.caller.parent.name & vblf _
& application.caller.pare...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 ...Excel-Multiple Cells Being Hi-lited
Sometimes when I'm setting up a worksheet and I left-click in a cell,
multiple cells in the same column are hi-lited. After it happens the first
time, it continues as I move through the worksheet, reducing my ability to
get work done considerably. After some trial and error, it seems to occur
when I've been adding and/or deleting columns and/or rows, after a header has
been installed. I can move throughout the worksheet using the arrow keys,
but it is a time consuming and cumbersome technique. I think the version I'm
using is Office Professional 2007 (file extensi...Text String to Unicode
How do I convert a text string (from a text file) that has escaped unicode
charactes (\u0635\u0641\u0627\u0631) to unicode chars?
Guilherme R. Rolim
Look at macros A2W etc.
Ajay Kalra [MVP - VC++]
"Guilherme R. Rolim" <firstname.lastname@example.org> wrote in message
| How do I convert a text string (from a text file) that has escaped unicode
| charactes (\u0635\u0641\u0627\u0631) to unicode chars?
| Guilherme R. Rolim
I'll try to put some more details, mayb...How do I convert time format to text?
I have a cell with a formula of =text(c3-b3,"h:mm") as the difference from
cell b3 and c3. Assume the result is 5:00. I need to minus another cell value
that is formatted as general text. eg. =text(c3-b3,"h:mm")-G3
Try the VALUE() fx and format that cell with your choice of Time Formats.
> I have a cell with a formula of =text(c3-b3,"h:mm") as the difference from
> cell b3 and c3. Assume the result is 5:00. I need to minus another cell value
> that is formatted as general text. ...moving text from a word document to excel
I'm moving a large amount of text from word documents to an excel
spreedsheet, and I have a few questions:
1. When I copy/paste text from the document to the spreedsheet, the text
will sometimes expand the cell very large. How can I keep all the cells the
2. When I click on a cell that has text in it to read it, sometimes it will
only show the text in a long downwards column, whereas other times it shows
it as a big 'blurb' to the right side (which makes it easier to read). How
can I set it up so it is not in a long column?
3. How can I insert cells without h...Go To an address specfied in a cell
Does anyone know how I can move the cursor to a cell, the address of
which is specified in another cell?
Here is the scenario. I enter a list of hours worked in a specfic week
on a data entry sheet. I hit a button and the values are copied to a
data summary sheet, the position depends on the Week No., the first
cell is specfied as the address "Data!29" for Week 5. I reckon I can
handle a recorded macro to copy and paste the data but how do I locate
the correct start cell?
I have tried copying and pasting into the GoTo box but that doesn't
Wee...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
...How do I increase size of text when typing?
I am using Word 2003 and with Word 2000 I could enlarge the size of the print
before typing to increase to 150% but cannot find how to do this in the 2003
version. The print on the screen is now about a 10 which is too small for
View | Zoom.
Suzanne S. Barnhill
Microsoft MVP (Word)
Words into Type
Fairhope, Alabama USA
"Sufimai" <Sufimai@discussions.microsoft.com> wrote in message
>I am using Word 2003 and with Word 2000 I could enlarge the size of the
>p...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...Formula to process 3 cells using IF statements
I have 3 columns of experimental data (C:E).
Row 30 contains the sums (C30:E30).
I need a formula that will examine the three sums and return the
column number that has the lowest sum. If more than one column is
lowest, select one randomly.
C30 D30 E30 Result
10 11 12 1 (C)
22 20 21 2 (D)
32 31 30 3 (E)
40 41 40 Randomly select 1 or 3
51 50 50 Randomly select 2 or 3
60 60 60 Randonly select 1, 2, or 3
Can this be done with IF statements or do I need to write a macro?
Well, this is a bit cumbersome, but it se...Excel 97 Worksheet Protection and cell colour
One of our users has setup a worksheet will a small range of cells that are
locked (they have formulas in them), he then protects the sheet.
He then wants to change the colour of some of the other cells, these cells
are not locked, but he cannot change the colour of the cells.
Is there an obvious solution?
AFAIK you can't do this in Excel 97 without first removing the
> Hi there,
> One of our users has setup a worksheet will a small range of cells
> that are locked (they h...center text when conditional format applied
Textbox control on Access 2007 form lost its centered alignment when
conditional formatting is applied. This did not happen in previous versions
I tried using format painter to apply conditional formats from a control
created in an earlier version, but this failed. The control created in the
earlier version then lost it's centering after saving in Access 2007.
Interesting. I tried to replicate this behaviour but failed, it all worked
as it should.
Try revisiting your form after applying the conditional formatting and
resetting the text box to center text.
...Bold text appears in print preview but does not print bold
I am working on a menu in Publisher. In print preview, all text in bold
appears bold, but when I actually print, portions of the bold text does not
print in bold. This problem applies to all text within specific text boxes.
For some text boxes the bold prints and for some it doesn't. Any suggestions
would be enormously appreciated.
What version Publisher? Don't know if that makes a difference however.
If you look in the font directory in the control panel you will see a separate
font for bold, italic, condensed and so on for fonts like Times New Roman and
Arial. If you use ...Coloring the Desired cells
I have a work sheet in which i have to look for word "Test" and color
the rows below it.
There are different words like "Test 1" "Test 2" and each set needs a
Can I get some help with the macro for it?
the number of rows in each group is not constanr.
Excel will need to know the logic of the rows and colors to be able to
determine how many rows to color. You say the number of rows is not
constant, but obviously you know how many rows to color. How do you know
t...excel locks up after selecting a cell #2
excel locks up after selecting a cell. When ever, I select a Cell, that will
automatically selects all the cell and this freezes the entire computer.
Can any body who would help me resolve this issue?
...Do a calculation in cells with text data format
I have a few columns of cells having a mixed data format of number and text.
Is it possible to convert the first row of numbers in text data format for
further calculation? Your guidance to accomplish it is appreciated.
"Ray" <NoSpam-ZQLi@GMail.com> wrote in message
> I have a few columns of cells having a mixed data format of number and
> Is it possible to convert the first row of numbers in text data format for
> further calculation? Your guidance to accomplis...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...Changing of Cell protections after saving Excel File (2002)
This problem occurs when I protect a document using a
macro 4.0 function: =PROTECT.DOCUMENT(TRUE,,,TRUE,TRUE).
When I use the function within a macro4.0 macro, on an
original file, everything works fine. The sheet has
unlocked cells, and when the sheet is protected, it
allows me to access those cells. But if I save the file,
or save.as another name, then the fun begins.
The enable selection of the sheet( view codes) has gone
from 0-xlNoRestrictions to -4142- xlNoSelection. This
locks me out of doing anything in the sheet. When I
unprotect and then re-protect the sheet using the
T...how do I change cell references automatically in formulas
In Excel 2000, I have data in 80 rows and 10 columns. Each week I add a new
row. I have a separate chart for each column with the data range from the
first row to the last.. Each week I have to change the data range to reflect
the new last row for each chart. Is there someway I can do this
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
"jnw3" <email@example.com> wrote in message