Converting Dates to Week Ending time period
This worked! Thanks folks!!
"Tim879" wrote:
try this formula. It assumes the date you want to convert (i.e. 6/14)
is in cell A14. It will always return the Friday following the date
you enter. If you enter a Friday, it will return the same date.
=+A14+7-IF(WEEKDAY(A14,1)=6,1,IF(WEEKDAY(A14,1)=7,2,WEEKDA Y(A14,1)+2))
On Jun 20, 9:18 am, drew wrote:
I am trying to convert a specific date to a Week Ending value. The week
starts on Saturday and ends on Friday for this example.
So.. any value from 6/14 through 6/20 would return a value of week ending
6-20-2008. Any suggestions? Thanks!
|