Week Ending Formula

This formula is helpful in doing a Timesheet form where you will need to generate the week ending date of the week data is entered. It is a fairly easy formula, but may same someone else the time in doing it. The example is for the week ending date of Friday. In the example, if it is Saturday, the week ending date is the next Friday. Hope this is useful. 
@If(@Weekday(@Today)=7;@Date(@Adjust(@Date(@Today);0;0;6;0;0;0));
@If(@Weekday(@Today)=5;@Date(@Adjust(@Date(@Today);0;0;1;0;0;0));
@If(@Weekday(@Today)=4;@Date(@Adjust(@Date(@Today);0;0;2;0;0;0));
@If(@Weekday(@Today)=3;@Date(@Adjust(@Date(@Today);0;0;3;0;0;0));
@If(@Weekday(@Today)=2;@Date(@Adjust(@Date(@Today);0;0;4;0;0;0));
@If(@Weekday(@Today)=1;@Date(@Adjust(@Date(@Today);0;0;5;0;0;0))
;@Today))))))

This was first published in February 2001

Disclaimer: Our Tips Exchange is a forum for you to share technical advice and expertise with your peers and to learn from other enterprise IT professionals. TechTarget provides the infrastructure to facilitate this sharing of information. However, we cannot guarantee the accuracy or validity of the material submitted. You agree that your use of the Ask The Expert services and your reliance on any questions, answers, information or other materials received through this Web site is at your own risk.

Back to top