1. N

    Select first row in list object

    Hi, everyone. I haveExcel template (xltm). I create eachweek a new workbook which contains an Excel table, aka list object, Itransfer/paste data to from another source daily. The new workbook starts with only one list row. I need to copy to first row on Monday, andthen Tuesday thru Friday I...
  2. B

    Formula for second weekday of the month

    Hi, Seen plenty of posts for formula for second Monday of the month or second Tuesday of the month. I want a formula for the second weekday in a month (weekday being a Monday, Tuesday, Wednesday Thursday or Friday)
  3. H

    Outlook Meeting Macro

    Hi I have never used VBA for Outlook before and was wondering would this be possible. I am looking to try schedule a macro to book a specific meeting room on specific days due to current restrictions on how far ahead the systems lets me book so currently I can I book the meeting room up to 4...
  4. W

    VBA Code – Convert Date Entry in spreadsheet to First Monday of any selected Week

    I’m hoping someone out there can help me with a VBA problem. I have created a timesheet to calculate the hours worked during a working week (Monday – Sunday) and would like a VBA code which will convert the date entered (for the 7 Days work period) - in my spreadsheet to the first Monday of the...
  5. B

    Formula to give me the day of the week for different months?

    Picture of what I am working with for reference: Imgur: The most awesome images on the Internet What I am trying to do is create a formula I can paste in B4 to give me the DAY OF THE MONTH for the correlating date in Janyary, February, etc. Since different days fall on different dates with...
  6. P

    First Monday of every month

    I have 12 Spreadsheets, one for each month. I need a formula that will give me the fist Monday of the month of the current year. If I have to put January, or whatever month, in a cell somewhere, I can. Thanks in advance.
  7. S

    Using IF statement to show data from Friday on Mondays

    Currently I have my data show stats for the previous day. For example on Tuesday I show Monday's data, on Wednesday I show Tuesday's data and so forth. I need help making a formula where on Monday's I can show Friday's data. I don't need to show the weekend data. I've played around with IF...
  8. D

    Getting a cell to highlight when a date is entered elsewhere

    Afternoon all. I think this is a bit of a complex one but I'll do my best to explain bit by bit. Basically, cell D5 will always need to show the date of the Monday of the current week, K5 will show the date of the next Monday and so on across the spreadsheet for about the next 10 weeks. What is...
  9. B

    HELP: if cell is first monday of the month then display month

    Hi, I have a columns displayed that are the first Monday of every week for 52 weeks; above that column I want to display the month if it is the first monday of the month. I can't figure it out. Please help.
  10. M

    Output Nth occurrence of day i.e. "First Monday of the month" from a Date

    Hi guys, this is my first post. I am in desperate need of an experts help please: I have a list of dates in excel (i.e. 12/05/2012) and I want to populate a corresponding column with the Nth occurrence of whatever day it happens to be in that particular month (i.e. 12/05/2012 would output "2nd...

Some videos you may like

This Week's Hot Topics