If the due date for the Ford Car Payment is the 5th of every month, I need the number $470 to populate into the cell if the date above the column is the 5th of the month or minus 6 days from it. Column B, cells (B6 & B7) are set with a plain text number corresponding to the day of the month it’s due (i.e.I’ve been having to put them in manually, but I’d like to automate it for the length of the bill (60 months) Row 6 and 7 are where I want the amount to show up.Column Headers: I have set these cells so that they auto-populate with the payday, which happens every week on Friday.What I’m trying to do is get a bill to populate with the amount, only if the particular payday falls exactly on or 6 days before the due date. I’m a little bit stuck on a complex spreadsheet formula (listed above). Using Google Sheets to make a budget (See attached image snapshots).
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |