Monthly Dates with Differing # of Days each Month

Microsoft Excel 2010 - complete product...
March 9, 2017 at 09:59:16
Specs: Windows 19
Hey all. I'm trying to create a budget. Of course, the due dates of my bills all occur at different times of the month. My paycheck comes every week, so sometimes I pay with the 4th check, sometimes the 5th, depending on the number of days in the month.

How do I write an "IF" statement so that IF the date at the top (formatted "3-Mar-17") is March 3rd, and before March 3rd, AND less than seven days prior, to enter "1000" (or whatever my rent is?

Thanks!


See More: Monthly Dates with Differing # of Days each Month

Report •

#1
March 10, 2017 at 10:36:57
I don't understand what you are asking.

IF the date at the top..."

At the top of what?

"(formatted "3-Mar-17") is March 3rd, and before March 3rd, ...."

How can the date be March 3rd and also be before March 3rd?

"AND less than seven days prior...

Prior to what?

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03


Report •
Related Solutions


Ask Question