# need to answer a date criteria question

I want to determine if a invoice date after a 45 day addition is applied falls in a calendar month in my spreadsheet, if it does i want it to populate the amount.
Date-formula-request.xlsx
###### Who is Participating?

Commented:
Sorry, I didn't read correctly - missed 45 days, so change to this

=IF(AND(\$A2+45>=D\$1,\$A2+45<=EOMONTH(D\$1,0)),\$B2,"")

see attached

regards, barry
27391243.xlsx
0

Commented:
Try this formula in D2 copied across

=IF(AND(\$A2>=D\$1,\$A2<=EOMONTH(D\$1,0)),\$B2,"")

For your example, of course, none of those cells will be populated because the date in A2 doesn't fall in any of those months

regards, barry
0

Author Commented:
Barry,

I want A2 to have 45 days added to it.  This was the invoice date, our cash payment expectations are 45 days later.

Thanks
0

Author Commented:
Sorry Barry, thought I granted you the solution & points.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.