+ Reply to Thread
Results 1 to 3 of 3

need to display first and last day of month based on a date in a cell

  1. #1
    Registered User
    Join Date
    05-24-2017
    Location
    USA, SC
    MS-Off Ver
    2010
    Posts
    8

    need to display first and last day of month based on a date in a cell

    I have to create a report that shows data was tracked from the first day of the month to the last day of the month. Currently this is pulled from a data file that tracks the use of a room, however if no one uses the room on the first or last day of the month, then it looks like we tracked only part of the month.
    For example, if A1 shows 09/03/17 as the first day the room was used and B1 shows 09/29/17 as the last day the room was used, then I'd like A2 to display the first day of that month 09/01/17 and B2 to display the last day of that month 09/30/17.
    Thanks for any help
    Last edited by radabm; 09-21-2017 at 07:54 AM.

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,036

    Re: need to display first and last day of month based on a date in a cell

    In A2
    =EOMONTH(A1,-1)+1

    In B2
    =EOMONTH(B1,0)
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    05-24-2017
    Location
    USA, SC
    MS-Off Ver
    2010
    Posts
    8

    Re: need to display first and last day of month based on a date in a cell

    So simple Thank you very much!

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 05-17-2016, 05:32 PM
  2. [SOLVED] Display the first date of the month when the month and year are selected
    By john dalton in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-05-2013, 11:59 AM
  3. Display the name of the month taken from a cell with a date
    By stevop622 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-09-2013, 05:39 AM
  4. [SOLVED] display days in month in the cell according to date
    By mraines in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 12-05-2012, 09:49 AM
  5. Display end of month date for previous month
    By erikwvb in forum Excel General
    Replies: 3
    Last Post: 06-20-2011, 01:22 PM
  6. [SOLVED] How to get a cell to display the date of the first day of the month
    By bugmenot in forum Excel General
    Replies: 2
    Last Post: 07-22-2009, 01:59 PM
  7. i want to display the month from a date into another cell
    By weazal5 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 04-26-2005, 04:06 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1