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

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

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

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

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

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