Howdy
A question to the enlightned ones of this forum
Help me figure out this
Information
* Payment dates cycle can fall either on 06/XX or 20/XX
* Expected range
-Bills received from 18/01 to 03/02: Payment date 06/02
-Bills received from 04/02 to 17/02: Payment date 20/02
-Bills received from 18/02 to 03/03: Payment date 06/03
-Bills received from 04/03 to 17/03: Payment date 20/03
How can I set a formula that will recognize the given range and bring the correct expected payment date?
Cheers
You will need the SUMIFS function for this. If you require any more specific help, please attach a sample workbook,
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
Howdy,
Here is the attached sample file
Paste the following formula into cell B2 and double click the fill handle to copy it down the column:Formula:
=IF(DAY(A2)>=18,DATE(YEAR(A2),MONTH(A2)+1,6),IF(DAY(A2)<=3,DATE(YEAR(A2),MONTH(A2),6),DATE(YEAR(A2),MONTH(A2),20)))
Let us know if you have any questions.
Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks