How to increment a list of dates
I have an Excel spreadsheet with a column of successive dates and I
want to devise a macro to increment the month by one, at the end of
each month so that I can use the sheet again. Is there as easy way to
why not just use a month number in cell e1 (or another and use)
"Bill" <email@example.com> wrote in message
> I have an Excel spreadsheet with a column of successive dates and I
> want to devise a macro to increment t...Compare and Highlight Rows
I have an excel file with two worksheets. is there a way to programatically
compare the two worksheets to find matches and highlight those matches on
They both have the same columns.
I want to compare the InspectionID column.
The Inspection ID column may have duplicates in both of the worksheets.
I have never done anything in excel above the beginner level. However, I am
a very skilled VBA programmer (programmed in ACCESS for over 10 years).
You may find it easier to use Conditional formatting instead:
For instance, with Sheet1 column A selected, and cel...add a hire date to the end of year (12/31/05) and get Total years
I need to determine how many years employees have been here. I know the
start date (example 6/02/98) At the end of this year (12/31/2005) this
person has been here 7 1/2 years. What is the formula to have excel figure
this, and display it in number form 7 1/2 or 7.5.
Depending on how accurate you need this to be you could use the formul
=(DATEDIF(A1,B1,"d")/365), where A1 is the employee's start date and B
is the year end date. This is only an approximation in the sense tha
a year isn't 365 days long but for the sake of this exercise it seem
I have a specific need to show 'month and year' and 'day, month and year' in
the same column. Because of multiple user input, I would like to make this
as simple as possible. If they enter 1/05, I want to see January, 2005 and
if the enter 1/10/05, I want to see January 10, 2005. From what I can see,
there is no way to format the entire column and acheive the stated goal. One
must choose one format and customize/reformat individual cells, which defeats
Any magic out there?
Maybe do this.........
Format column A as TEXT
Go ahead and enter 1/10, 1/10/05, ...Date/Time field calculation
i am trying to make a sum calculation on a field that keeps duration of
time. How can i do this? I get errors or zero as result.
On Jun 21, 10:02 am, Stathis <s_paraske...@hotmail.com> wrote:
> i am trying to make a sum calculation on a field that keeps duration of
> time. How can i do this? I get errors or zero as result.
You need to do the calculation at a level at least 1 level below what
you want the answer to be in.
msgbox DateDiff("h", #6/20/2007 1:00:00 AM#, #6/20/2007 1:30:00
will give an ans...highlighting #2
I was told that although that there is no official
highlight button for publisher like there is for word but
there are ways to get around it. I am using the 2003
version of publisher. does anyone know the trick.
Make a small box and fill it with whatever color you want. Place it behind
your text and then group it with your text.
MVP Microsoft [Publisher]
"justin" <firstname.lastname@example.org> wrote in message
> I was told that although that there is no official
> highlight button for publish...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 ...How do I convert a Julian date into a regular date?
I have a long list of Julian dates that are formatted as follows:
The first number is the year, i.e. 2003, 2001, 2000.
The next three numbers are the numeric equivalent of where that date falls
in the year, i.e. 300=Oct 27, 296=Oct 23, and 346=Dec 12.
Excel talks about how to convert to a Julian date, but I have not found how
to go from a Julian date to a regular date that I am used to seeing.
That is not real Julian dates, for your problem you can go to
real Julian dates is the number of days that ha...Date Function 03-26-10
If a cell has text and numeric (date) is there a way to pull the date out
Product dropped off on 11/01/2009 by Michelle Smith
I would like to see 11/01/2009
Format as Date
Microsoft Excel MVP
"Jen_T" <JenT@discussions.microsoft.com> wrote in message
> If a cell has text and numeric (date) is there a way to pull the d...How do I add on 15 days to a specified date
Column D of my spreadsheet has the dates that I begin various tasks
I would like Column E to automatically fix a date 15 days later to be my
Target Completion Date Goal.
Then I would like Column F to tell me how many days left until the Target
Date in Column E
The dates in Columns D & E would not change; but the Days Left in Column F
would change each day.
Please tell me what formulas I should put into Columns E & F
Many thanks in advance.
ILanger, with date in D2, in E2 put =D2+15 in F2 put =E2-TODAY() and format
Always backup your data before trying somethi...Help organizing date
I have a list on a worksheet to organize purchases by the buyer where each
the first column designates
whether the purchase is a book...b or music...m or video...v.
I want to make a master sheet where all the buyer's information is sorted by
the catagories listed above.
So if Sam bought 1 book 1 video and 1 music (on one worksheet) and Paul
bought 2 books
5 videos and 2 musics(on another worksheet), how do I show on a master sheet
the date resorted to show all the books music etc in separtate catagories . I
want to not just count the books etc, but have the information that follows
i...Setting traffic lights based on todays date against target dates
I have a spreadsheet I use for calculating target dates for issue of
At the top I have a cell containing todays date I1
One column contains the first date of the result issue process ie cell
Next column contains the target date for result issue - cell E6 which
is calculated by formula (20 workdays after the date in D6)
I need to set up a traffic light system in conditional formatting which
highlights the target date in E6, firstly amber when today(I1) is 9
workdays after the date in D6, and then a second condition turning to
red when today (I1) is 12 workd...date value
can anyone tell me which formula shows the value of a date?
is this u r trying say ?
On Nov 29, 11:17=A0pm, "Mosaddeq Aziz" <mosaddeq.a...@gmail.com> wrote:
> hi all,
> can anyone tell me which formula shows the value of a date?
will always update to show today's date.
Mosaddeq Aziz wrote:
> hi all,
> can anyone tell me which formula shows the value of a date?
It's not clear what you are asking!
But to...get number of monday, tuesday,... between 2 dates
Hi, how can I get number of monday, tuesday,... between 2 dates?
Racsus (Racsus@discussions.microsoft.com) writes:
> Hi, how can I get number of monday, tuesday,... between 2 dates?
DECLARE @offset int,
SELECT @day = 'Tuesday'
SELECT @offset = CASE @day
WHEN 'Monday' THEN 1
WHEN 'Tuesday' THEN 2
WHEN 'Mittwoch' THEN 3
WHEN 'Thursday' THEN 4
WHEN 'Friday' THEN 5
Hi - just switched to Outlook 2003 from OE. I can't work out how to set up a
rule where the message is a different color for a certain sender as I did in
O! - can anyone tell me?
You can set flags on messages from certain senders.
You can set the color of the font used in the list view using Conditional
Formatting: View menu > Arrange by > Current View > Customize Current View >
"Daskarzine" <Daskarzine@doesnotexist.com> wrote in message
> Hi - just switched to Outlook 2003 from OE. I can&...how to get several payment dates
i can't think of how to do this, mabey someone can help me.
i have a tbl employees (not our employees but employees from a company thet
we sold to)
i have the $ amount sold and the # of payments they have to do (credit) this
payments vary in that some are every 7 days others every 14, 15 or 30 days,
so say an employee bought $100 in Feb-02-2007 and has a credit of 8 weekly
EmpID = 1
EmpAmount = $100
EmpCredit = 8
EmpDays = 7
EmpDate = 02/02/2007
now i need to calculate very date we expect payment from them:
EmpID EmpNextPay1 EmpNextPay2 EmpNextPay3 EmpNextPa...Last Contact Date 07-27-07
I hope someone can assist me. I would like to create a field on the Contact
Entity called “Last Contact Date” (this was a cool field that my previous CRM
application had). I have no problem creating the field, but I am looking for
the best way to populate the field. Any suggestions would be greatly
Where do you get the last contact date data from? populated with Last
Modified Date? The easiest way is to do an SQL update. I have done
that many times to a datetime field and it's not going to break
anything. Just remember this is at you...Date format 04-20-10
Text in Column E is a date mddyyyy
I need to calculate the age but the text format of this date is throwing off
the number. Any suggestions
Excel isnt just a program its a metaphor for life. Sometimes it is easy and
boring.. sometimes it is a little challenging and great.. then there are days
it will drive you absolutely INSANE.
To calculate the age with data as such ...try
LEFT(TEXT(A1,"00000000&qu...Outlook Today Calendar button
I have a situation where a user is downloading emails to a local folder
but reads his Calendar from the server mailbox instead. I have modified
the outlook.htm file which is embedded in outwvw.dll as shown below to
allow the Outlook Today page to reflect the calendar from server
<param NAME="Module" VALUE="Calendar">
<param NAME="Path" VALUE="\\Mailbox - XXX\Calendar">
-----------------------------------------------------------...Dates in a report
I am a database that is tracking customers and their contract amounts. In a
report I want to be able to basically take the date today Date() and then
take the date they were customers and multiply by how many years it's been
times their annual contract amount.
I hope this isn't as confusing as it sounds basically i want to do something
todays date 12/19/2007-12/19/2005=2 years as customer * $300 (annual
I would want to put this in a report and I know how to use the control
source. Could someone please assist me in how I would do this.
Thank y...can't highlight cell
When I click on a cell, the contents of the cell are not highlighted.
Instead the cell's row and column are highlighted. I can't work with the
cell or it's formula itself. Help!
Tools>Options, Edit tab, check Edit directly in cell
Microsoft MVP - Excel
"MM" <MM@discussions.microsoft.com> wrote in message
> When I click on a cell, the contents of the cell are not highlighted.
> Instead the cell's row and column are highlighted. I can't work with the
&...Text highlighting in a TreeList?
Using a TreeList in a dialog, is it possible to add some text
highlighting to some of the lines, like changing the color, or making it
(There's no indication I can find in my Newcomer book that this is
possible, but it's a 9 year old book.)
Yes. Owner-draw/Custom-draw tree controls did not exist when I wrote that chapter of the
book. Now you would handle the NM_CUSTOMDRAW notification and handle them otherwise like
most owner-draw controls.
On Wed, 21 Nov 2007 15:58:00 -0800, David Deley <email@example.com> wrote:
>Using a TreeList in a dialog, is it possib...highlights
Can you help me and tell me if this is at all possible using conditional
formatting or a formula
I4 is to equal to b4 times c4. If d4 is not the same as i4 then d4 needs to
highlight in red. However if d4 is a negative number then d4 should remain
normal, not highlighted.
mvpearl omitthisword at verizon period net
"Shorty" <Mysteryjim@sbcglobal.net> wrote in message
> Hi all
> Can ...highlight color using keyboard(shortcut)
Could you please tell me how to use keyboard (short cut) to highligh
color for any cell or row in excell without moving a mouse to color ta
in tool bar menue.
Thank you for your help
~~ Message posted from http://www.ExcelTip.com
~~View and post usenet messages directly from http://www.ExcelForum.com
Fairly long key sequence to do it through the menu, rather
impractical... my suggestion is to record a marco and
assign it a keyboard shortcut.
Nikos Y.(nyannaco at in dot gr)
>Could you please ...displaying multiple dates in a table
any help/advice is much appreciated.... let me explain...
i have this table w/c have multiple date/time fields... corresponding to
birthdays of people. a single record of a person contains his birthday, his
spouse's name & birthday, and also his sons/daughters names & birthdays...
now i have already done a query in w/c i can get all persons birthday to
display per month (month parameter)...
i have done a query just like the one i made above, and it will display
the spouses & sons/daughters birthday corresponding to the month i typed in.
but the query also displaye...