-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Project date of money running out based of daily expenditure
Excel Facts
Select all contiguous cells
Pressing Ctrl+* (asterisk) will select the "current region" - all contiguous cells in all directions.
If you're interested Tweedle (or anyone else that is listening, lol),
I would like to add a range, in let's say column G. This range would be individual dates to consider as dates that I spend nothing. So what I mean is: if a date is in this range (of say 30 cells down) then exclude this date OR not so much exclude but more so consider as a date that I spend $0-like Sundays.
What sort of sub or function would I need here?
I would like to add a range, in let's say column G. This range would be individual dates to consider as dates that I spend nothing. So what I mean is: if a date is in this range (of say 30 cells down) then exclude this date OR not so much exclude but more so consider as a date that I spend $0-like Sundays.
What sort of sub or function would I need here?
Upvote
0
Similar threads
- Question
- Question
