Query

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: "Sumit" <sumitagg@xxxxxxxxx>
Date: 17 Dec 2005 21:07:40 -0800

Hi,

This is my first post to this group. I have the following query

I have put some date in cell A1 (eg. 03/11/2005). In Cell A2, 1 have
written 3 (which represents. No. of months). Now, in cell A3, i want a
date which is later than so much months as given in Cell A2 from the
date in Cell A1.

i.e. The formula should be such that, i get the result 03/02/2006 in
cell A3 if i put 03/11/2005 in Cell A1 & 3 In cell A2.

Regards,
Sumit

.

Follow-Ups:
- Re: Query
  - From: Arvi Laanemets
- Re: Query
  - From: Bill Kuunders
- Re: Query
  - From: JE McGimpsey

Prev by Date: Re: Subtracting Hours - Eastern to Pacific/Central
Next by Date: Re: Statement of Account
Previous by thread: RE: Including objects based on a condition
Next by thread: Re: Query
Index(es):
- Date
- Thread

Relevant Pages

Re: Excel VBA Passing Parameters Through Cell
... While recording the macro and trying to pass ... So, instead of recording while selecting a cell to grab the data, I ... when opening the query through Microsoft Query (selecting ... I am not able to put single quotes around the dates directly in the ...
(microsoft.public.excel.programming)
Re: RangeName Define Limitations
... It was a great look at the Query Wizard. ... I was never able to see the parameters to point the update to cell E1 ... I did my range name for my data validation pick list based on a name ... Then..on the LISTS sheet... ...
(microsoft.public.excel.programming)
RE: auto Refresh MS Query SQL Server
... both those abilities are built into the querytable in Excel so it is not ... size but also means that the query data is not saved and must be refreshed ... Then, when the query results are displayed, go back to a cell ... > My user needs to right click to refresh data every time. ...
(microsoft.public.excel.programming)
Re: splitting text strings into new fields
... I'm not sure what you mean by cell. ... I'm working with an Access query and I ... am putting the formula on the criteria line in the query for the field "sales ... I am hoping to extract out only the sales office, ...
(microsoft.public.access.queries)
Re: Make a Cell Act like a Button
... You can use almost anything but a cell for this. ... onto your sheet, say an Autoshape or a Textbox. ... choose "Assign macro" and assign your macro. ... > That number of streets determines how long each query string will be. ...
(microsoft.public.excel.programming)