On 2002-03-06 08:39, Sami wrote:
hey mark i no u can do this. but the formula in the other thing didnt work. plz tell me how to enter weeks into excel!!!! thanks
On 2002-03-06 09:42, Mark W. wrote:
Sami, if what Scott is suggesting satisfies your requirements you might want to use the following instead...
=TEXT(A1,"mm/dd/yy")&" - "&TEXT(A2,"mm/dd/yy")
On 2002-03-05 11:17, Sami wrote:
i dont no how u make them stick together n excel recognises them as a week? how do u make weeks? n how do i group the sales data into weeks and put the weekly sales revenue in a workbook?