HOW DO I EXCLUDE SUNDAYS FROM AN EXCELL SHEET FOR PROJECTING SALE

C

CARGUY

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?
 
O

OssieMac

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?
 
Top