Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Exclude Lines in the calculations on a spread sheet | Excel Worksheet Functions | |||
How to open MS Excell 2007 Sheet in MS Excell 2000??? | New Users to Excel | |||
If function with date; if sale is Oct place sale $ amount here | Excel Worksheet Functions | |||
insert query into excell sheet to update excell sheet and pivot table | Excel Discussion (Misc queries) | |||
skus in columm a for each sale, qty. of skus sold, each sale in co | Excel Worksheet Functions |