| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Date wild
is there a symbol that can be used to develop a date function. What I am
looking for is (something/14/something) first something is month last is year. Need to inject an amount into a cell on the 15 automatically Thanks |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date wild
Hello Curt, There is no symbol to insert a date either in the Excel worksheet formulae or in VBA. You might consider an "=IF" formula in the cell to accomplish the task. If there is some reason a formula wouldn't work then perhaps a VBA macro would work. -- Leith Ross Sincerely, Leith Ross 'The Code Cage' (http://www.thecodecage.com/) ------------------------------------------------------------------------ Leith Ross's Profile: http://www.thecodecage.com/forumz/member.php?userid=75 View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=57559 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date wild
Can you describe in more detail what you are attempting to do; that is, describe this "inject" process you want to do. Also, where are the "something" and "something" located... in the cell on the worksheet or in code? By the way, you are seeking a VB solution (you posted in a programming newsgroup), right?
-- Rick (MVP - Excel) "Curt" wrote in message ... is there a symbol that can be used to develop a date function. What I am looking for is (something/14/something) first something is month last is year. Need to inject an amount into a cell on the 15 automatically Thanks |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date wild
have a wkssheet that data is compiled on for expenses. Want to insert into a
given cell an amount on the 15th of the month. Think this should be able to dowith a date formula. Problem is the month changes as does the year. This is the reason I was looking for wildcards for month and year. The formula could be anywhere on worksheet to insert the amount when the date is reached. I am not sure if this needs to be done in code or a excel function. The sheet I need this to go into is one of many in program. A thought just pased me a worksheet chg except how can this be triggered by a date. To me its the changeing dates that puzzles me. Really appreciate the help all of you provide Thanks "Rick Rothstein" wrote: Can you describe in more detail what you are attempting to do; that is, describe this "inject" process you want to do. Also, where are the "something" and "something" located... in the cell on the worksheet or in code? By the way, you are seeking a VB solution (you posted in a programming newsgroup), right? -- Rick (MVP - Excel) "Curt" wrote in message ... is there a symbol that can be used to develop a date function. What I am looking for is (something/14/something) first something is month last is year. Need to inject an amount into a cell on the 15 automatically Thanks |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date wild
I'm still not clear, from you description, on what your setup is or exactly
what you are looking for, but perhaps this will help. If you put a month number in A1 and a year number in B1, then you can construct a date for the 15th of that month and year using this... =DATE(B1,A1,15) -- Rick (MVP - Excel) "Curt" wrote in message ... have a wkssheet that data is compiled on for expenses. Want to insert into a given cell an amount on the 15th of the month. Think this should be able to dowith a date formula. Problem is the month changes as does the year. This is the reason I was looking for wildcards for month and year. The formula could be anywhere on worksheet to insert the amount when the date is reached. I am not sure if this needs to be done in code or a excel function. The sheet I need this to go into is one of many in program. A thought just pased me a worksheet chg except how can this be triggered by a date. To me its the changeing dates that puzzles me. Really appreciate the help all of you provide Thanks "Rick Rothstein" wrote: Can you describe in more detail what you are attempting to do; that is, describe this "inject" process you want to do. Also, where are the "something" and "something" located... in the cell on the worksheet or in code? By the way, you are seeking a VB solution (you posted in a programming newsgroup), right? -- Rick (MVP - Excel) "Curt" wrote in message ... is there a symbol that can be used to develop a date function. What I am looking for is (something/14/something) first something is month last is year. Need to inject an amount into a cell on the 15 automatically Thanks |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Date wild
Do you think that will work without the year also how can I have the month
number update each month. This entry needs to be put in monthy. It is a auto withdrawl from account. This I want to post to my sheet monthly auto. Hard to express clearly I know. I would like to see this happen every time it is say the 15 of any month any year. My hang up is the changeing months and wish to leave out the year. Hope this helps explain. Thanks "Rick Rothstein" wrote: I'm still not clear, from you description, on what your setup is or exactly what you are looking for, but perhaps this will help. If you put a month number in A1 and a year number in B1, then you can construct a date for the 15th of that month and year using this... =DATE(B1,A1,15) -- Rick (MVP - Excel) "Curt" wrote in message ... have a wkssheet that data is compiled on for expenses. Want to insert into a given cell an amount on the 15th of the month. Think this should be able to dowith a date formula. Problem is the month changes as does the year. This is the reason I was looking for wildcards for month and year. The formula could be anywhere on worksheet to insert the amount when the date is reached. I am not sure if this needs to be done in code or a excel function. The sheet I need this to go into is one of many in program. A thought just pased me a worksheet chg except how can this be triggered by a date. To me its the changeing dates that puzzles me. Really appreciate the help all of you provide Thanks "Rick Rothstein" wrote: Can you describe in more detail what you are attempting to do; that is, describe this "inject" process you want to do. Also, where are the "something" and "something" located... in the cell on the worksheet or in code? By the way, you are seeking a VB solution (you posted in a programming newsgroup), right? -- Rick (MVP - Excel) "Curt" wrote in message ... is there a symbol that can be used to develop a date function. What I am looking for is (something/14/something) first something is month last is year. Need to inject an amount into a cell on the 15 automatically Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| wild cards? | Excel Discussion (Misc queries) | |||
| Wild Card!!!??? | Excel Programming | |||
| Its a wild one, maybe. | Excel Discussion (Misc queries) | |||
| Wild curser | Excel Discussion (Misc queries) | |||
| Wild curser | Excel Discussion (Misc queries) | |||
Linear Mode
