Link to home
Start Free TrialLog in
Avatar of SPXHT
SPXHT

asked on

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
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image
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
Avatar of SPXHT
SPXHT

ASKER

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
ASKER CERTIFIED SOLUTION
Avatar of barry houdini
barry houdini
Flag of United Kingdom of Great Britain and Northern Ireland image
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SPXHT
SPXHT

ASKER

Sorry Barry, thought I granted you the solution & points.