i need creating formula (if it's possible).
creating new budget sheet, , trying automate as possible. paid bi-weekly, , budget on per pay period case rather month month. means on budgets have 1 set of bills due, on i'll have different set of bills due.
so, let's have bill, bill a, due on 7th every month. assume have 1 cell contains start date budget period , 1 contains end date period. need write if statement says:
if 7th falls in date range provided (i.e. if bill due during budget) put amount due in cell, else put zero.
know how (if) can this?
are thinking of using excel this, or programming language?
i'm thinking of sort of if/then/else statement.
in excel, have a1 start date budget period, b2 end date period, , c3 amount due.
cell (or won't) include amount due this:
=if(and(today()>=a1,today()<=b2),c3,0)
excel little squirrelly "and" function. give try.
Forums Macs Mac Apps and Mac App Store
- iPhone
- Mac OS & System Software
- iPad
- Apple Watch
- Notebooks
- iTunes
- Apple ID
- iCloud
- Desktop Computers
- Apple Music
- Professional Applications
- iPod
- iWork
- Apple TV
- iLife
- Wireless
Comments
Post a Comment