PDA

View Full Version : [SOLVED] Automatic Friday Week Ending Dates



oam
02-09-2015, 06:27 PM
Using Excel 2007

I would like know if it is possible to have a formula that will automatically enter the date for a Friday Week Ending Date based on a 7-day pay period. In addition, when the next pay period starts the next week, the date would automatically update (update on Saturday) to the new Week Ending date.

I am trying to use the following formula but Excel 2007 does not adjust for week ending dates on Friday.

=T1+(7-WEEKDAY(T1,2))


Example:
Week Ending Date: 13 Feb 2015
On Saturday of the next week, the date would automatically be 20 Feb 2015

Can this be done?
Thanks for your help

Bob Phillips
02-10-2015, 01:14 AM
How about

=T1+7-(WEEKDAY(T1+1))

oam
02-11-2015, 05:34 PM
Thank you for quick reply!

The formula works great, Thank you