Creating a formula to a cell containing a date #2
Works perfectly. This forum rocks!!
hb2474's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=418
View this thread: http://www.excelforum.com/showthread.php?threadid=26433
...Calendar locks up
Operating System: Mac OS X 10.5 (Leopard)
Processor: Power PC
Email Client: Exchange
When I switch to calendar, I get the spinning beach ball for 10 minutes or more. Finally, it displays an old version of the calendar and the error message: <br><br>An unknown error (-116) occurred. <br><br>This only happens on one of two desktop computers and never on my laptop. <br><br>I've reinstalled Entourage, performed a Test identity and eliminated an event that I thought was problematic. None of this works. <br><br>Thanks in advance...Re-format date (mm/dd/yyyy into dd/mm/yyyy)
Could someone help me with the following:
I have a range of dates which I want to convert from mm/dd/yyyy into
dd/mm/yyyy, my formula
works for most of the dates though in case of 1/12/2007 where the
month only has one position (instead of 01) my formula takes "1/" for
mm (instead of "01")
Can one of you advice how to capture this issue in my (or a different)
You could try: Data > Text to Columns > Next > Next >...Excel 2003 "File Open": how keep folders at top with sort by Date.
With "File Open" in Excel 2003, how can I keep the folders at the top when I
have the view set on Details and sorting by Date Modified so that the newest
stuff is at the top? I was previously using Excel 2000 and it kept the
folders at the top automatically (as did Excel 97).
I use xl2k at work and I know that I have to resort this list in the File|open
dialog lots of times--so I'm guessing that your memory might be a bit faulty.
(But I'm getting older, too--so maybe it's my memory that's fading. I do know
that I click to sort lots of times!)
Aging Analyst wrot...x-axis dates dont match up with the nodes on the line graph
Does anyone know why this is happening. My other graphs using the same
time and date on the X and percentage values on the Y are matching up
right where they should but for some reason this one sheet isnt letting
the X-axis match up to the correct values?
changetires's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=35414
View this thread: http://www.excelforum.com/showthread.php?threadid=570496
Are you using line or XY charts?
If it's a line chart, is the axis...calendar #22
can you check off events on the calendar like you can in a Franklin Planner.
I know you can on the tasks menu, but I need it on the calendar page as well.
Calendar items don't have a completion value, only tasks do (as you've
"Becki" <Becki@discussions.microsoft.com> wrote in message
> can you check off events on the calendar like you can in a Franklin
> I know you can on the tasks menu, but I need it on the calendar page as
...First date of next month?
I have a cell where I put a date A1. I need a formula where it will
produce the first date of the next month.
Thanks for any help.
Message posted via OfficeKB.com
"Randy" <email@example.com> wrote in message
> I have a cell where I put a date A1. I need a formula where it will
> produce the first date of...Appointment time incorrect when scheduling appopintment
When I create an appointment after 8am the appointment shows up in the
scheduling view as 4 hours later. Windows 2K, Office XP. If I schedule
appointment at 7 or 7:30 the scheduling shous up as correct time. Have SP4
on OS and SP3 on Office Please reply to firstname.lastname@example.org
...Bold individual dates on a yearly calendar
I am trying to create a yearly calendar with only certain dates bolded. How
do I "unlock" text so that I can?
Select the month, copy, paste special as a table. You will have to re-size the
table to fit the space, but now you can bold the dates.
Another solution would be to create individual months through the Design
Gallery. Each month would have to be re-sized, but the calendar is already in
If you have Publisher 2003 the Design Gallery has a wizard wand on the bottom of
the calendar month. Once you re-size the calendar month, you can copy/paste and
change the d...Weekly calendar printing style starting in middle of week for Outlook 2003 #2
I was wondering if it was possible to print in Outlook 2003, a trifold
printing style where the weekly section starts mid-week. Is this possible?
...Conditional Formatting Dates 02-18-10
I am attempting to highlight past due dates (I am horrible with the formula's
and can not seem to figure out how to NOT highlight if there is no
information in the cell's)
A1=Planned date and A2=Completed date
Conditions I am trying to figure out
1. Would like A1 to highlight RED if less than Now and A1 is NOT BLANK or A2
2. Would like A2 to highlight green if filled out and less than or equal to A1
Thanks anyone that can help!!!
CF formula for A1:
CF formula for A2:
Is it possible to set up repeating meetings in Calendar without having to do
a separate calendar for each month?
Use text boxes rather than typing directly into the cells. That way you can
copy/paste the text boxes into the following months. You can move the boxes
around to the proper day(s).
Mary Sauer MSFT MVP
"OSL Office" <OSL Office@discussions.microsoft.com> wrote in message
> Is it possible to set up repeating meetings i...WM_TIMER remaining/elapsed time...
I am fairly sure there isn't a straight forward way to do it but I
thought I'd ask more knowledgeable people here first.
let say I create a timer for 10 minutes.
::SetTimer( m_hWnd, TIMER_IDENT, 600000, NULL ); // WM_TIMER sent to
Is it possible to 'pause' the timer or at know how many ms are left
before the WM_TIMER event is fired?
On Apr 29, 11:29=A0am, Simon <b...@example.com> wrote:
> I am fairly sure there isn't a straight forward way to do it but I
> thought I'd ask more knowl...Clock time is wrong in received e-mails
I recently installed Microsoft Office 2003 on my new computer (Windows 7). I
am using Outlook as my email program.The time shown on received e-mails is
exactly two hours prior to the actual time. My computer clock is accurate.
Any help in correcting this will be appreciated.
Checked the time zone in Outlook?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact.
ALWAYS post your Outlook version.
How to ask a question: http://support.microsoft.com/KB/555375
After furious head scratching, Pat asked:
| I recently installed Micr...One Appointment with 2 Reminders
Does anyone know if you are able to set two separate reminders for the same
For example, if I have a meeting scheduled for 6pm, and I need a reminder
that morning (to remind me to bring materials), as well as a reminder 15 or
30 minutes prior, can this be done within that one appointment without
creating a separate task or appointment?
When you read the first reminder, set it to Snooze for the desired time
instead of dismissing it.
Allison Sutterfield wrote:
> Does anyone know if you are able to set two separate reminders for the same
> appointment? ...Outlook 2003 Shared Calendar
I have access to a shared calendar and emails, I am receiving appointments
for that person with the request that I accept them. Is there a way to turn
off the requests for appointments that I receive for that person and just let
them receive and answer their own requests?
Yes. They need to change the Outlook settings on their computer so that you
are no longer a Delegate to their calendar. Tools | Options | last tab on
right (I don't have it in front of me right now - Permissions or Delegates I
think it says).
w...Calendar Control 11.0
I am using Excel 2003 and have inserted the object Calendar Control 11.0 but how can this link to anything? How can I use the date I select on the object in the spreadsheet in anyway
- in design mode double-click on the calendar object
- in the appearing VBA editor window insert the following code:
Private Sub Calendar1_Click()
ActiveSheet.Range("a1").Value = Calendar1.Value
> Dear All,
> I am using Excel 2003 and have inserted the object Calendar Control
> 11.0 but how can ...converting text to proper dates
Hi, I have got a column full of "dates" that are actually just text of
the form "Jun-06-2008". No matter how I change the formatting of
these cells, they are not being read as dates. Is there an automated
way for me to convert these into what Excel will recognize as dates?
Thanks very much. Excel 2007, if it makes a difference -
First thing I do with those is run them through Data>Text to Columns
Select entire column then..............
Next>Next>Column Data Format>Date>MDY and finish.
Gord Dibben MS Excel MVP
On Thu, 21 Apr 2011 06:58:23 -0700 (...DPM 2010 release dates
Hi, I was wondering if anyone could define what the current projected release
dates for DPM 2010 are? I'm specifically looking for RC and RTM dates.
I've heard that the RTM is now expected to ship in early summer and wanted
Here is an old information I gathered before. I am not sure it is still
accurate. So lets wait for the DPM team's answer:
Santhosh Sivarajan | MCTS, MCSE (W2K3/W2K/NT4), MCSA (W2K3/W2K/MSG), CCNA
What is the best way to plot time series data? For instance, I have plotted
columns of data against time using "X-Y (Scatter)" chart instead of "line"
chart. Is one preferred over the other? Also, when adding additional data
to the chart, I can use "Chart->Add Data", or I can simply copy a column and
use "Paste Special" to paste it into the chart. Is there no difference
between the methods?
In general I prefer XY charts, although a Line chart provides a nice
axis, if you want a tick on the first of each month, say, and the months
to be sp...Calendar missing from Outlook Folder List
I have 3 users whose pc's were recently reimaged to WinXP with Outlook 2003
as part of the image. The team who did the reimage basically copies their
old Outlook profile (from the Win2K image) incorporates it into the WinXP
image. Since the reimage, all 3 users have the calendar missing from their
Outlook folder list.
So far, I haven't been able to find anything in Outlook help or Technet that
addresses this problem. Does anyone have any suggestions?
Jim Cesarini <email@example.com> wrote:
> I have 3 users whose pc's were recently re...How do I turn off the updating of the date on an excel invioce
If i pull up an invoice to reprint it the date changes to the current date
How do i turn this feature off?
Put in the date manually by using Ctrl + ; in the first place when you
create the invoice
I assume you have either TODAY() or NOW() and they will update with each
"Isoking555" <Isoking555@discussions.microsoft.com> wrote in message
> If i pull up an invoice to reprint it the date changes to the current date
> How do i turn this feature off?
...Time phase sales based on award dollar amount.
At work we get awards over a year duration or so around 2M dollars.
Sales start slow, ramp up, then descend. Some type of normal
distribution. Sales are not just the average amount divided by the
award. Is there some way I can setup a dollar value and period of
performance to generate an estimated time phasing of sales for each
On Apr 22, 5:27=A0pm, joe <cegarb...@gmail.com> wrote:
> At work we get awards over a year duration or so around
> 2M dollars. Sales start slow, ramp up, then descend.
> Some type of normal distribution. Sales are not just the
> average amoun...Losing Entourage calendar items
Operating System: Mac OS X 10.5 (Leopard)
Email Client: pop
I was working on my calendar setting up some May 2010 dates and I needed to refer to January and discovered Entourage is erasing previous months were of appts. events dates etc. from March 2010 back! How do I prevent it from erasing my calendar items, I want to preserve everything.
...Two calendar dates in one cell..??
I have a Microsoft Publisher calendar document that was created in 2005 that
shows the dates Monday - Sunday. When I print it, it will not print out any
that fall after the fifth week (eg January 2006 it prints up to January 29th
but not the 30th or 31st). These are in an "overflow" area. But when I open
the calendar part in Word to edit the calendar, it appears normally and that
sixth week shows up just fine. I need that sixth week to print OR I need to
do the split date feature (I would prefer the split date).
How can I set up the numbers in one of those cells so i...