Results 1 to 6 of 6

Formula to calculate days in month Item is Held

Threaded View

Prof Sick Formula to calculate days in... 07-29-2020, 08:52 AM
Phuocam Re: Formula to calculate days... 07-29-2020, 09:02 AM
Prof Sick Re: Formula to calculate days... 07-29-2020, 09:06 AM
Rick Rothstein Re: Formula to calculate days... 07-29-2020, 10:16 AM
ChemistB Re: Formula to calculate days... 07-29-2020, 09:32 AM
Bo_Ry Re: Formula to calculate days... 07-29-2020, 09:58 AM
  1. #1
    Forum Contributor
    Join Date
    12-20-2017
    Location
    California
    MS-Off Ver
    Office 365
    Posts
    104

    Formula to calculate days in month Item is Held

    Hi,

    In the attached file, in the area highlighted in yellow, I need help trying to figure out how to populate in each month, how many days a item will be held until sold. There is a purchase date and a sale date referenced. This will calculate how many days the item is held.

    I'm trying to figure out how many days it will be held in month 1, month 2, month 3 etc. I've filled in the cells manually for purposes of example.

    Thanks in advance.

    -Manny
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need formula to calculate days used in month initiated in previous and selected month
    By Ochimus in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-14-2021, 05:54 AM
  2. [SOLVED] Formula to calculate how many days in a month have Daylight Savings
    By kersplash in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 12-21-2018, 03:39 AM
  3. [SOLVED] Formula to calculate working days and calendar days per month-year ?
    By donny007 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-05-2018, 06:23 PM
  4. [SOLVED] Need formula to calculate days in each month across multiple Start and End dates
    By Ochimus in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-25-2017, 04:19 PM
  5. [SOLVED] Formula needed to calculate working days in specified month between two dates
    By webfeet2 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-24-2013, 02:19 AM
  6. Replies: 1
    Last Post: 12-09-2012, 06:01 PM
  7. formula to calculate numbers of days (i.e. Monday's) in a month
    By Carol in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-06-2007, 07:31 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