LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Vass
 
Posts: n/a
Default Calculate sales in the week by day ?




"Vass" wrote in message
...
"Bob Phillips" wrote in message
...
Sorry, missed that bit



Bob, it doesn't like looking at my date and year at F1 and F3
I'm using Month(E2) pulling from a cell with +today() in it

so the cells F1 and F3 have '3' and '2006' in them

any ideas ?


Scrap that, its working fine now, thanks Bob
--
Vass


 
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
Macro to copy cells to rows below [email protected] Excel Discussion (Misc queries) 1 January 20th 06 06:59 PM
Macro to insert copied cells [email protected] Excel Discussion (Misc queries) 17 January 18th 06 10:40 AM
HELP! Single cell formula to calculate weeks cover of stock on forward sales. [email protected] Excel Worksheet Functions 2 January 13th 06 10:24 AM
Calculate Total Sales from a Database John Excel Worksheet Functions 0 November 3rd 05 12:26 PM


All times are GMT +1. The time now is 07:13 AM.

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"