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.
Who is Participating?
barry houdiniConnect With a Mentor Commented:
Sorry, I didn't read correctly - missed 45 days, so change to this


see attached

regards, barry
barry houdiniCommented:
Try this formula in D2 copied across


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
SPXHTAuthor Commented:

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

SPXHTAuthor Commented:
Sorry Barry, thought I granted you the solution & points.
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.

All Courses

From novice to tech pro — start learning today.