PC Review


Reply
Thread Tools Rate Thread

add on date specfic

 
 
Curt
Guest
Posts: n/a
 
      26th Feb 2009
Am trying to have a amount added to a cell on a specific date (IE: 15) I want
it to add to the amount all ready in the cell.

=IF((M4=123),123)
This gives me 123 into ("C26") When the next ("!5") date comes up will this
add to the amount all ready there. If I try to chg dates in excel formula I
get FALSE. I tryed to chg dates to see if it would update no go. Can this be
done on worksheet or must it be done in VBA
Not sure what to try next.
Thanks
 
Reply With Quote
 
 
 
 
T. Valko
Guest
Posts: n/a
 
      26th Feb 2009
*If* you want to add the *same* amount for each 15th of the month this could
be done by counting how many 15th of the months have passed since a base date
then multiplying by the amount and it would continue to add the amount into
the future.

Is this something that might work for you?


--
Biff
Microsoft Excel MVP


"Curt" wrote:

> Am trying to have a amount added to a cell on a specific date (IE: 15) I want
> it to add to the amount all ready in the cell.
>
> =IF((M4=123),123)
> This gives me 123 into ("C26") When the next ("!5") date comes up will this
> add to the amount all ready there. If I try to chg dates in excel formula I
> get FALSE. I tryed to chg dates to see if it would update no go. Can this be
> done on worksheet or must it be done in VBA
> Not sure what to try next.
> Thanks

 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I search for a name/specfic info? =?Utf-8?B?U3RldmUgUA==?= Microsoft Access 5 14th Feb 2006 12:47 PM
What is authenticating against a specfic DC =?Utf-8?B?RGVzcGFpclVL?= Microsoft Windows 2000 Networking 0 28th Apr 2005 10:38 AM
How can restrict users using printer at specfic date Pleo Microsoft Windows 2000 Security 0 9th Sep 2004 02:39 AM
How can restrict users using printer at specfic date Pleo Microsoft Windows 2000 Networking 0 9th Sep 2004 02:39 AM
How can restrict users using printer at specfic date Pleo Microsoft Windows 2000 Printing 0 9th Sep 2004 02:39 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:34 PM.