Date if before or after 15th of month

W

wf315

Hello-

My due date should be the 1st of the month if the start date is after the
15th or the 1st of the previous month if the start date is before the 15th,
but only if there is an amt in B7 otherwise blank.


B2=Start Date
B7=Amt
C7=Due Date
 
T

TomPl

You did not indicate which way to go if the start date is the 15th. This
formula placed in cell C7 assumes that is the start date is the 15 it will be
due the following month:
=IF(ISBLANK(B7),"",IF(DAY(B2)<15,DATE(YEAR(B2),MONTH(B2),1),DATE(YEAR(B2),MONTH(B2)+1,1)))

Pay them bills!
 
W

wf315

Thanks Tom - I meant to say on or before the 15th. How do I enter it? You've
been a great help and time saver :)
 
T

Teethless mama

Try this:

=IF(B7="","",EOMONTH(B2,(DAY(B2)>15)-1)+1)

It required ATP add-ins
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help needed with a formula for dates in excel 2007 2
Conditional Formatting based on dynamic Date 1
date formula returns the 15th or the end of month 8
Calculating Previous Pay Dates 8
Excel Progress Bar Showing Progress of Month 0
Divide month into two payroll periods 5
Formula help needed 2
Difference between last date of month and given date 3

Top