+ Reply to Thread
Results 1 to 3 of 3

Help needed for fender bender budget sheet! Formulas

  1. #1
    Registered User
    Join Date
    02-17-2017
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    2

    Help needed for fender bender budget sheet! Formulas



    Hi All! I've been looking for a budget sheet for this year to keep track of income vs expenditure for my wife and I with pensions etc, and found a great template which is EXACTLY what I'm looking for.... Except (!) I can't for the life of me get the line items from 'Itemized Expenses' to show up in the monthly or YTD sheet?
    The date on the main YTD sheet says '2013' at the top, and if I change it to 2017, the dates in the itemized sheet go to the 'text' format, and I'd like to change the currency symbols to GBP, which I can do in the 'custom' section of cell formatting, but CANNOT for the life make the 'MONTHLY EXPENSES SUMMARY' pick up the date that I've entered. I used to think I was reasonable (Excel 03) but getting old, forgetting a lot combined with being COMPLETELY out of my depth is not helping the cause!
    Does anyone have a moment to tell me where I've come unstuck (other than tackling something thats beyond me!) I'd really like to try to understand it.

    Many thanks indeed.
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,256

    Re: Help needed for fender bender budget sheet! Formulas

    What version of Excel do you have? Workbook requires 2013 or later.

  3. #3
    Registered User
    Join Date
    02-17-2017
    Location
    London, England
    MS-Off Ver
    2016
    Posts
    2

    Re: Help needed for fender bender budget sheet! Formulas

    I appologise for not adding that, John, a rather important bit of information! I am using Microsoft Office 2016 (Word, Excel and Outlook). Many thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Formula needed to calculate budget phasings based on dates
    By Kez35 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-23-2016, 05:22 AM
  2. Nested IF statement to show under budget, within a % of budget, over budget
    By clafleur in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-15-2015, 10:36 AM
  3. Racing Sheet - HELP wth formulas Needed
    By DirigoServices in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-31-2014, 12:46 PM
  4. [SOLVED] 2014 budget spreadsheet with conditional formulas
    By 6string in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2013, 04:54 PM
  5. budget formula. 2 different formulas for yearly budget SUMIF?
    By italianstallion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-04-2013, 05:20 AM
  6. Budget Question-Find hours needed per week
    By zedii in forum Excel General
    Replies: 3
    Last Post: 04-01-2012, 03:23 PM
  7. Daily Budget Formula Needed
    By sammir in forum Excel General
    Replies: 1
    Last Post: 02-07-2012, 02:30 PM

Tags for this Thread

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