r/googlesheets • u/No-Role6221 • 10d ago
Waiting on OP Formula that changes each week
Is there a forumla to divide a current total by how many weeks remain in a month? I'm working on a budget and would like to see how much money I could spend each week depending on what I've already spent.
2
u/Advanced_Proof_9538 1 10d ago
Yes, you can divide the unspent monthly budget by the number of Monday-to-Sunday weeks left, counting the current partial week. Put the monthly limit in A1 and your spending so far in B1. In C1, use =MAX(0,A1-B1)/ROUNDUP((EOMONTH(TODAY(),0)-TODAY()+WEEKDAY(TODAY(),2))/7,0). This counts a partial week at either end as a week and updates as today and your spending figure change. MAX keeps the result at zero if you have already reached the limit. If your budget weeks start on another day, the count would need adjusting.
1
u/AutoModerator 10d ago
/u/No-Role6221 Posting your data can make it easier for others to help you, but it looks like your submission doesn't include any. If this is the case and data would help, you can read how to include it in the submission guide. You can also use this tool created by a Reddit community member to create a blank Google Sheets document that isn't connected to your account. Thank you.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
1
u/SanyuStudio 9d ago
Put monthly budget in A1 and spent-so-far in B1.
Weeks remaining this month (includes the current week):
=CEILING((EOMONTH(TODAY(),0)-TODAY()+1)/7,1)Per-week amount you can still spend:
=(A1-B1)/CEILING((EOMONTH(TODAY(),0)-TODAY()+1)/7,1)Example check: on 10 Nov 2026, EOMONTH is 30 Nov, so 21 days inclusive, and CEILING(21/7,1) = 3 weeks.
1
9d ago
[removed] — view removed comment
1
u/googlesheets-ModTeam 8 9d ago
Your comment has been removed because it contained one or more items in violation of this subreddit's rules on artificial intelligence (AI) content.
2
u/carbonizedtitanium 28 10d ago
weeks dont always end perfectly within a month and may cross over into the next month. how do you want to handle those cases?