+ Reply to Thread
Results 1 to 2 of 2

Value of Cell increases with Date

  1. #1
    Registered User
    Join Date
    09-19-2006
    Posts
    1

    Value of Cell increases with Date

    Hello,

    I would like to know what formula I would use to have a cell's value increase with the start of a new month. ie cell a1 grows by $500.00 at the start of every month.

    Thanks

  2. #2
    Forum Contributor
    Join Date
    12-12-2005
    Posts
    667
    Assuming the date in cell A1 is:
    =MONTH(DATE(2006,8,1))
    and Cell B1:
    =MONTH(NOW())
    then cell C1 is:
    =(B2-A2)*50

    Since the Now function is volatile, it will update autooatically!
    Best regards,

    Ray

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1