• 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.

Need an Help in Function

Aadhya

New Member
I need a formula to calculate the case created week I have case created date like: 1/14/2020 and case week starts from Date wise, like Jan 1- Jan 7, Jan8-Jan14 ,Jan15-21, So i wanted a column for case created week
Ex: If case created on 1/14/2020, Created week should Display as Jan 8- Jan 14, If case created on 1/15/2020, created week should display as Jan 15- Jan 21
 
The Monday prior to the case-created date is given by
= caseDate - WEEKDAY( caseDate, 3 )
and the following Sunday is obtained by adding 6.
To return the dates as text you need the TEXT function to convert dates (numbers) into formatted text
= TEXT( caseDate - WEEKDAY( caseDate, 3 ), "mmm d" ) & TEXT( caseDate + 6 - WEEKDAY( caseDate, 3 ), " - mmm d" )
 
Back
Top