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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Transpose columns to rows in groups 4
Display weeks from a Milestone 0
How do I exclude a cell from a range? 4
How to change Sunday from default start day of week 0
Calculating Turn Around Times excluding Sunday 1
Code copies ONLY last j from sheet 9
Unable to sum the specific cells containing both text & values 5
Calculate the number of days to exclude Sunday & Holidays 6

Top