Date wild

  • Thread starter Thread starter Curt
  • Start date Start date
C

Curt

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
 
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?
 
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
 
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)
 
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
 
Back
Top