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