ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   HOW DO I EXCLUDE SUNDAYS FROM AN EXCELL SHEET FOR PROJECTING SALE (https://www.excelbanter.com/excel-programming/426979-how-do-i-exclude-sundays-excell-sheet-projecting-sale.html)

CARGUY

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?

OssieMac

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?



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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com