Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: FORMULAS USING DATES?

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    U.S. Navy
    Posts
    5
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've got a spreadsheet that lists, among other things, beginning balances, amounts to be paid, and ending balances (Beginning - paid = ending). Is there any way to make this formula occur ONLY, and automatically, on the 1st of every month without any user intervention? If I was to leave this file closed for 2 months and then open it, what would it take for it to realize 2 months have passed and process the amount paid twice?

    Scott

  2. #2
    BatCoder
    Join Date
    Feb 2002
    Location
    Turkey
    Posts
    816
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hi Scott,

    If we will just use formulas in excel sheet to do this then you need a starting date/month as reference point. Say your A1 cell has this value as 01.01.2002

    Now in A2 you can find the diffence of months beginning month and now with this easy formula:

    =MONTH(NOW())-MONTH(A1)+1

    It says (if we are in April now) 4 months and say you are increasing values by 1.15 multiplier for each month (means 15%). Now you can use B1 cell to calculate multiplier like below:

    =1.15^A2

    Easy? And you should care about year differences, please let me know to explain it also if you like this kind of solution.

    Regards
    Suat

  3. #3
    Board Regular
    Join Date
    Feb 2002
    Location
    Georgia USA
    Posts
    569
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Could you use something like this =IF(TODAY()>=A2,B2-C2,"") this will subtract C2 from B2 if the date in A2 is grater than or equal to today’s date, if not it will return “”, Blank.

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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