weekday function

The function =TEXT(A30,"dddd") will place the text of the day of the week dependent of the cell value. 1 = "Sunday", 2 = "Monday" etc. But (apart from using multiple iff else statements), is there a reverse of this that will provide a value dependent on the text of the day. IE "Sunday" = 1...

Hi experts! I created 4 queries (get&transform) to upload data from some folders. The ETL processes and the schema are perfectly connected and running. I even added steps to change the locale in each column and the format date/time (d/m/yyyy hh:mm:ss) to just date (d/m/yyyy). After I had...

Dear All, I currently dispose of a working sheet which I use to keep track of my working hours. We recently have upgraded our Microsoft Office 2010 to Microsoft Office 365 and this particular sheet has stopped working correctly: it shows a lot of #value! errors. I have found how to correct the...

I am writing a macro to try and sort some payroll information. On the worksheet, column "I" contains the "payroll end dates" for accounting records in the spreadsheet. I have used the following section of code to find the max date column "I" and assign it to a variable: Dim lastEndDate As Long...

I need a formula, way to input the dates of every Wednesday and Friday since 01/07/2105 so for example the dates I require int he pattern would be: 01.07.15 03.07.15 08.07.15 10.07.15 15.07.15 17.07.15 and so on - every Wednesday and Friday. Rather than typing out the actual date is...

I am trying to average the values of a range of cells based on the day of the week. The spreadsheet is setup as follows: <tbody> Column A: Column B: 1/4/15 23.90% 1/5/15 14.39% 1/6/15 4.62% 1/7/15 5.71% 1/8/15 18.32% 1/9/15 31.62% 1/10/15 11.28% 1/11/15 13.13% 1/12/15...