• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Date Formula Question_Follow-up for dates falling on same weekly cut-off

N

NazieO

New Member
Hi,

I want to assign a follow-up date the following week for dates that fall on the same week cutoff (start of week is Friday).
I'm trying to create an automatic pay date formula for transactions that fall under a certain cutoff. Here's an example
Column A - includes transaction dates
Column B - to return expected pay date based on the formula calculating the value in Column A

Scenario:
Any transactions between Friday the previous week to Thursday 11:59PM of the current week are scheduled to get paid on Thursday next week. So the cutoff really is Thursday before midnight (Thursday 11:59pm) of the current week for it to get paid the following Thursday.

Examples:
Nov 21, 2024 (Thu, until 11:59pm) transaction gets paid Nov 28, 2024
Nov 22, 2024 (Fri) transaction gets paid Dec 5, 2024
Nov 26, 2024 (Tue) transaction gets paid Dec 5, 2024
Nov 28, 2024 (Thu 11:59pm) transaction gets paid Dec 5, 2024
Nov 29, 2024 (Fri) transaction gets paid Dec 12, 2024

Thank you so much, will appreciate any response and guidance.
 
You must log in or register to reply here.
Back
Top