Results 1 to 2 of 2

FIRST day of month formula!!!!!

This is a discussion on FIRST day of month formula!!!!! within the Excel Questions forums, part of the Question Forums category; Hi, in cell B13 I have a date, 04-Jan-2010 I cel A2 I have a formula that looks @ cell ...

  1. #1
    Board Regular
    Join Date
    Oct 2007
    Location
    Amsterdam
    Posts
    293

    Default FIRST day of month formula!!!!!

    Hi, in cell B13 I have a date, 04-Jan-2010

    I cel A2 I have a formula that looks @ cell A1 and adds 1 month while taking into account weekends and some pre defined busines days.

    =WORKDAY(DATE(YEAR($B$13),MONTH($B$13)+ROW(A1),DAY($B$13))-1,1,'Business Holidays'!$A$2:$A$74)

    In this case it would yield 04-Jan-2010.

    I need to alter this formula in a way that it takes the first day of the month in cell B13 instead of the actuall mentioned date (04-jan-2010).

    any ideas???
    Thank you for your help
    Excellians...AWOOO...AWOOO...AWOOO

  2. #2
    MrExcel MVP
    Moderator
    Rediscovering the love
    Richard Schollar's Avatar
    Join Date
    Apr 2005
    Location
    UK
    Posts
    23,677

    Default Re: FIRST day of month formula!!!!!

    Given a date value in cell B13, the first day of this month can be calculated using:

    =B13-DAY(B13)+1
    Richard Schollar

    Using xl2013

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com