saturday

HI, I hope I formulated the topic correctly. What I want to do is to multiply Rooms by ADR for each date and sum them together to get total revenue for all days in a given segment (for example in row 5 and the result will be in cell S5). I thought of going with SUMPRODUCT but cannot figure out...

I have an Excel 2010 Spreadsheet. In Column A I have a list of names and in column B I have a list of dates. I would like to know if it is possible to create a pop-up box that will inform me if any of the names in Column A have worked on a Saturday, Sunday or any Bank Holidays. Column A is...

On 22nd Nov 2014 we are hosting a SQL Saturday in London. It is being done under the umbrella of the PASS organisation, SQL Saturday is their free community events, but this is a very different SQL Saturday. We are aiming it Excel Pros who munge/crunch/manage data. There will be the usual nods...

can weeknum work with the week starting on saturday instead of sunday or monday? if not, what are my options?

Hi I'm trying to put together a sickness calculator that works on a rolling year basis. I need to count the number of days between two dates, but only count the working days, which are Tuesday, Wednesday, Friday and Saturday (so exclude Mondays, Thursdays, Sundays and bank holidays) and only...

Dear All, I have a unique problem, I want a function like the "WORKDAY". But in that function the saturday is also used as the "Holiday" (Counted on 5 days/week) I need the Sat to be excluded from list of holidays (Counted on 6 Days/Weeks). I went thru the entire formulae given in excel...

hi all, i'm new here. juz found out about dis forum thru search. been scrolling around thru the posts n i'd appreciate it if sum1 take sum time n look at a minor problem i'm facing. i m living in a country dat quite a number of d population still work on Saturdays. dis causes a bit of a...