• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 188
  • Last Modified:

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
0
SPXHT
Asked:
SPXHT
  • 2
  • 2
1 Solution
 
barry houdiniCommented:
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
 
SPXHTAuthor 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
 
barry houdiniCommented:
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
 
SPXHTAuthor Commented:
Sorry Barry, thought I granted you the solution & points.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now