first day of week

  1. R

    Calculating Weeks of the Month starting before the 1st

    Hi All, I've been scouring the internet to try to find something and so far have come up short. I found a very good reference in terms of date functions at http://www.cpearson.com/excel/WeekNumbers.aspx and http://www.cpearson.com/excel/DateTimeWS.htm#NthDoW but it's not quite what I'm...
  2. J

    VBA math and firstdayofweek

    Hi there, I've got two questions today: First: How can I automatically return the first day of the week in vba. I want to do this completely without any user input, i.e. how can I properly code this: Format(FirstDayOfWeek, "mmdd"). Second: How do you multiply and divide cells using vba? I...

Some videos you may like

This Week's Hot Topics

Top