LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 39
Default Converting Dates to Week Ending time period

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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Entering week ending dates Jenilise Excel Discussion (Misc queries) 3 September 14th 07 12:04 AM
How to format cells to show dates as the week-ending date of that dereksmom Excel Worksheet Functions 1 July 12th 06 04:40 PM
Counting dates greater than a certain time period [email protected] Excel Worksheet Functions 7 April 26th 06 11:25 PM
Converting time period in hours Jorge Excel Worksheet Functions 11 March 6th 06 04:18 AM
Starting work period on a Saturday and ending on a friday JLyons Excel Discussion (Misc queries) 1 February 17th 05 02:28 PM


All times are GMT +1. The time now is 05:38 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"