Date Picker


Is there a DatePicker in Excel 2007 so I can pick a date when I focus
on a cell?

If not, where can I get one?

11/26/2009 3:28:16 PM
excel 39879 articles. 2 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 15

Look here:

Kind regards,

Niek Otten
Microsoft MVP - Excel

"shapper" <> wrote in message
> Hello,
> Is there a DatePicker in Excel 2007 so I can pick a date when I focus
> on a cell?
> If not, where can I get one?
> Thanks,
> Miguel 

11/26/2009 5:56:13 PM

Similar Artilces:

When copying from "date" cell to "general" cell, how to keep date.
An Excel question for you: when I try to copy data from a "date" formatted cell over to a concatenate formula in a "general" formatted field, it transfers the data over as the boolean value. This is causing endless headaches because I am trying to upload the information into our financial software. Do you know a solution for this? I think you mean the date comes over as the serial value. If not, this may not be right. In the concatenate function, embed the Text function. ex: A1 has 5/16/2004, B1 has "TEST" in it. C1 formula would be =concatenate (TEX...

changing date
i have a code set up currently like this in thisworkbook open: Range("K3") = Now() Range("K3").NumberFormat = "mmmm d, yyyy" is there a way to have it so that in userform6, my commandbutton1 whe clicked will return the value back to the originally saved date and no today's date. reason being it is for an invoice program, when they use a new one i comes out with todays date which is good, but the next day or next wee they can go back to look at the invoice. when this happens it doesn' reflect the actual date of the invoice, rather the date at that poin...

YTD showing Life to date in Smartlists
I am having trouble with the Customers and Receivables transaction Smartlists showing life to date, when the column name is Total Sales YTD. Does anyone have any suggestions as to why this might be happening? Ta, Travis. Hello Travis, That data is extracted from the summary table. It might be that you need to reconcile your data in order for the right data to show up, that is if your summary data is not correct. Kind Regards Eddie Fourie MBS Specialist TV> I am having trouble with the Customers and Receivables transaction TV> Smartlists showing life to date, when the column na...

Adding time to date-time formatted cell
Not sure quite how to do this... I have a cell (A1) which I have formatted to read the date and time (MM/DD/YYYY HH:MM AM/PM). That is my starting time. What I want to do now is be able to input a time period in hours (A2) and have another cell (B1) add those hours to A1 so B1 will read the "ending time" - formatted with the (MM/DD/YYYY HH:MM AM/PM) format. Is this possible? Thanks! Basically, I want it to lay out like this: Cell A1: 8/12/05 2:00am Cell B1: 12 (it takes 12 hours to run this process) Cell A2: 8/12/05 2:00pm Thought that might make it more clear what I&...

Modifying Date Range 2
Now, I need to modify the expression: Between [Forms].[frmReport].[StartDate] And [Forms].[frmReport].[EndDate] Is there a way to modify the expression above so that: [StartDate] mm/dd/yyyy mm=01, dd =01, and yyyy= the year entered and [EndDate] mm/dd/yyyy mm= the month entered, dd= the day entered, and yyyy= the year entered A date is entered into [StartDate] and [EndDate] from the form “frmReport” in the format of mm/dd/yyyy. Thanks Again -- Message posted via Thanks Ken -- Message posted via

Long Date / Between and...
Hi all, I just converted from 2003 to 2007 and at the same time I took the opportunity to “clean up” some in tables…I changed [DateCreated] format from short to long date since the Date/Time stamp Is valuable (previous I used one separate date and time) ..Here is the issue. Running the query with the parameters in the [DateCreated] field, Between(First Date) AND (Second Date) does not function.. what am I doing wrong? Thanks! Changing the format of a field doesn't actually change what's stored in the field: it just changes how it's presented. If DateCreate...

Calculating new date by entering number of additional workdays
Would love some assistance with the following: If I have a start date in a cell (A1), I am hoping to enter a number of additional workdays into another cell (B1), resulting in a new date -- skipping weekends -- in a third cell (C1). Looking for the formula for C1. If it helps, here's an example: * Start date = 4/1/10 (which is a Thursday) * Additional workdays = 5 * Solution = 4/7/10 (because it skipped the weekend) Thanks in advance. Hi Ensure that you have the Analysis Toolpak loaded. Tools>Addins>Analysis Toolpak then with startdate in A1, number of days t...

Subtract a group of cells from a total based on ending date
I don't know if this has already been discussed or not but I couldn't find anything about it so here's my question: I am working on a spreadsheet that calculates interest owed based on how many months have been paid on a contract. The original spreadsheet was based on a formula that took the date of the last payment and subtracted it from the current date, then calculated the interest on that period of time. Well, that doesn't work if the contract is a 2 year contract from 2001 and is already over. We can't charge more interest than what they were originally quoted,...

Problems moving Microsoft Date and Time Picker Control on MFC dialog
I've got an MFC CDialog class that displays and manages a dialog. There are several controls on the dialog (combo boxes, edit boxes, static text boxes, etc.). Included in the mix are four Microsoft date and time picker controls. The dialog is used in three separate instances. Not all of the controls are relevant in all three instances so we hide the controls that aren't relevant in each instance, move the controls around on the screen, and resize the dialog to eliminate dead areas on the dialog. We are getting the CWnd for each control and using the SetWindowPos method for each control...

Tax Posting Date come from GL Posting Date
Option in to have the Tax Posting Date come from either the Transaction Posting Date or the GL Posting Date. From KB 865532: "The purchases/sales amounts and the taxes are organized into each period based on the actual transaction date in the subsidiary module, such as Receivables Management or Payables Management. The GL posting date has no effect on which period the tax will be reflected." ...

Storing data in Short Date format
Hi, I have produced a couple of other Access databases where, in the Table design, I have selected Short Date and only the date has been stored in the table. In the current database I am working on I have selected Short Date on table fields but find that the date AND time is being saved. This is causing problems whem I want to seach by date. Can anyone suggest why, on this occasion, Short Date format is causing date and time to be saved (like the General Date format) when data is entered through a form (where the control is also set to Short Date format)? The problem is evident on all t...

switch off transforming number into date
"aa" <> wrote in message news:%2323$vYzhKHA.5604@TK2MSFTNGP04.phx.gbl... > How do I switch off that autocomplete or autoformat or whatever the name > of > that feature, which transform a decimal number like 12.42 into > marcian-looking date like Dec.42 ? > It does it at random in some cells > > You might also look at "Transitional formula entry" in the customization settings. mike ====================== in my Options-->Transitions--> the box Transition formula evaluation is not ticked ...

How do I enter a date typing 040906 and have it appear 04/09/06? I
I would like to format a cell so that I can just type in the numbers in a date and have the cell display the date with the forward slashes added automaticly! Example type in only 040906 and have Excel display 04/09/2006 in the cell. You cannot format a cell to do this. Chip Pearson's site has event code that will look after the change as you enter the numbers. Gord Dibben MS Excel MVP On Mon, 11 Sep 2006 13:52:02 -0700, Stover <> wrote: >I would like to format a cell so that I can just type...

Bulk Date Change on Activities
Am new to CRM 3.0 however I would like to find a way of changing the due date on mulitple activites. I would like to be able to select multiple activites then apply possibly a rule that asks for a new due date for all activities selected. Anyone got any ideas???? ...

Dates not formatting on Chart
I have some spreadsheets linked to each other and the data is being displayed in some charts. Now, when I look at the dates on the bottom of the chart, it is displaying 39095 and several other numbers. I have formatted all of the of dates to display as mm/dd/yyyy but it is not changing the dates. I have enter in my information again and I am still not having any luck. I really don't want to have to build these charts again. Any help would be appreciated. Thanks When you state: " I have formatted all of the of dates to display as mm/dd/yyyy but it is not changing the dates&quo...

concatenating two fields in one cell, of which one is a date.
I have two cells: Cell A2 Today's date is Cell A3 02/08/2007 I want cell A4 to state: Today's date is 02/08/2007 When I use the formula =CONCATENATE(A2," ",A3) I get the following: Today's date is 17669 How do I make this state [Today's date is 02/08/2007] in one field? One way: =A2&" "&TEXT(A3,"dd/mm/yyy") Or =CONCATENATE(A2," ",TEXT(A3,"dd/mm/yyy")) Regards Trevor "Manuel Murieta" <> wrote in message news:e0Cvbw8SHHA.480@TK2MSFTNGP02.phx.gbl... >I have ...

formating dates #2
i am new here so forgive me if this is an old or stupid question. i have excel 2000 and i am trying to enter in dates for a check book register. i set the format for the cell to date to xx/xx/xx . when i enter in a date of 010203 for jan 2nd 2003 i get a date of 01/14/55 i can not figure this out. i am sure i am doing something wrong since i do not use this that often. please any help is greatly appreciated thank you mike c Mike, You need to enter the date as 01/02/03, so that Excel will then recognise it as a date. Otherwise it treats it as a serial number, and calculates the date as t...

Ability to enter a invoice due date.
Why doesn't Great Pains allow for the entery of a due date for invoices? Currently you have to trick GP with an invoice date in the future. Also, why doesn't Great Pains have an Invoice Date field that isn't used to drive the posting period. The date keyed should drive the period that an invoice is posted too, while the invoice date should drive when the invoice is paid. Great Plains is the worst accounting system that I have ever seen. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for...

Join tables by dates
I have 2 tables that I need to join. The first table contains the fields PhoneNumber, FromDate, Todate, PlanCost. The second tables contains the fields PhoneNumber, DateOfCall, CallCost. There are multiple plans for each phone number in the first table as the phone plans change over time. I want to add the phone plan, to the second table, that relates to the date of the call so that I can check we were being charged the correct amount. Any ideas? "Ryan" <> wrote in message

date time consolidation
I have two separate cells. One with data one with time. I need to make the two cells into one with the date and time. Seems simple but..... The method you use to accomplish this will depend on how the date and time information is stored. Excel can >store< information one way and >present< it in another. An Excel compliant date is in fact a large integer number: today, 10 Feb 2010, is stored as the integer 40219. An Excel compliant time is a fraction of a day: 6:15 pm is stored as a decimal portion of a day, or 0.760417. Test how the data is stored by reformatting the...

Use Current Date on text file
I'm have a button on a form that will transfer text from a query to a text file on my c:drive named "testfile05-01-07.txt" I need to transfer text everyday, once a day. I don't want to overwrite the file each time. Instead I want to create a new file each day with the above name but the current date: example testfile05-02-07, then on the next day a new file should be named "testfile05-03-07", etc.. Here's my code to transfer to the text file: DoCmd.TransferText acExportDelim, , "QryExport", "c:\temp\testfile05-01-07. txt", True Please h...

recurring anniversary dates
Trying to highlight recurring anniversary date. ex: Hire Date: 02/04/2003 receives new vacation on 02/04/2005. Highlight that date every year to remind to reset vacation dates. Can this be done just using the mm/dd, not the year, And have it stay highlighted until vacation dates reset, then go back to normal? Using MSExcel 2000 Thank You Blackhawk ...

Trouble formatting Date data
I am using a Line chart to plot specific milestones over a series of dates. Each line in the chart represents the series of data and its progression over time. I have managed to create each series of data with my dates showing up in the X axis as a Time-Scale. However, I need my categories (the names of the milestones) to appear in the Y axis and I can't figure this out. I also want to experiment with having the dates appear in the Y axis, and categories in the X, although this does not appear to be possible. I believe this would represent my data more meaningfully. Your help i...

Formatting Date in Header or Footer
How can I change the default date format (8/18/2004) in the header/footer to a different date format (18-Sep-04)? Is there a way without using VBA? Thanks Hi see your other post -- Regards Frank Kabel Frankfurt, Germany "Emile Zac" <> schrieb im Newsbeitrag news:u16wacYhEHA.3320@TK2MSFTNGP11.phx.gbl... > How can I change the default date format (8/18/2004) in the header/footer to > a different date format (18-Sep-04)? Is there a way without using VBA? > > Thanks > > ...

Wrong date on home page brings up 2 year old investments-can't cha
When I open Money 2007, my date showing on the left side is 2 years off-not exact. I have tried to advance it when I look at my investments page but it says I can't set a date in the future. Can this date be changed to refllect my current totals? I hate to reload everything. I reloaded a backup from a week ago but it didn't correct the problem. Please help, thanks. =?Utf-8?B?VGVk?= <> wrote in > When I open Money 2007, my date showing on the left side is 2 years > off-not exact. I ...