Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default HOW DO I EXCLUDE SUNDAYS FROM AN EXCELL SHEET FOR PROJECTING SALE

I HAVE AN EXCELL SHEET THAT KEEPS TRACK OF OUR DAILY SALES, WE ARE CLOSED ON
SUNDAYS. HOW DO I EXCLUDE SUNDAYS FROM MY SALES PROJECTION FOR THE MONTH?
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2,510
Default HOW DO I EXCLUDE SUNDAYS FROM AN EXCELL SHEET FOR PROJECTING SALE

Can you post a sample of how your data is set up?

Like do you have daily actual sales figures etc against dates?

Are you attempting to just project for the remainder of a current month or
are you trying to project for some months in advance?

--
Regards,

OssieMac


"CARGUY" wrote:

I HAVE AN EXCELL SHEET THAT KEEPS TRACK OF OUR DAILY SALES, WE ARE CLOSED ON
SUNDAYS. HOW DO I EXCLUDE SUNDAYS FROM MY SALES PROJECTION FOR THE MONTH?

Reply
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
Exclude Lines in the calculations on a spread sheet DLAYMANS Excel Worksheet Functions 2 September 13th 08 04:30 AM
How to open MS Excell 2007 Sheet in MS Excell 2000??? Alek Luchnikov New Users to Excel 1 March 22nd 07 04:40 PM
If function with date; if sale is Oct place sale $ amount here [email protected] Excel Worksheet Functions 1 January 30th 06 09:07 PM
insert query into excell sheet to update excell sheet and pivot table vbsolo Excel Discussion (Misc queries) 0 August 24th 05 12:41 PM
skus in columm a for each sale, qty. of skus sold, each sale in co confused1 Excel Worksheet Functions 1 June 11th 05 09:44 PM


All times are GMT +1. The time now is 06:02 AM.

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

About Us

"It's about Microsoft Excel"