+ Reply to Thread
Results 1 to 8 of 8

Count of Days per month for a contract period

Hybrid View

sspilla Count of Days per month for a... 12-14-2020, 06:06 AM
davsth Re: Count of Days per month... 12-14-2020, 06:23 AM
Shareez Saleem Re: Count of Days per month... 12-14-2020, 06:27 AM
sspilla Re: Count of Days per month... 12-14-2020, 08:35 AM
Shareez Saleem Re: Count of Days per month... 12-14-2020, 08:44 AM
davsth Re: Count of Days per month... 12-14-2020, 08:46 AM
sspilla Re: Count of Days per month... 12-14-2020, 09:34 AM
davsth Re: Count of Days per month... 12-14-2020, 11:58 AM
  1. #1
    Valued Forum Contributor
    Join Date
    04-27-2015
    Location
    Abu Dhabi, U.A.E
    MS-Off Ver
    Office 365 | 2016
    Posts
    697

    Re: Count of Days per month for a contract period

    Formula: copy to clipboard
    =IF($F2<G$1,"No",IF(MONTH($F2)=MONTH(G$1),DAY($F2),DAY(EOMONTH(G$1,0))))
    Attached Files Attached Files

  2. #2
    Registered User
    Join Date
    12-14-2020
    Location
    Riyadh
    MS-Off Ver
    2016, 365
    Posts
    3

    Re: Count of Days per month for a contract period

    Hi Shareez- Thanks for your support. I found some anomalies with the formula especially if the start date is in 2020 and end date is in 2020 or 2021.
    row numbers 7,31,36,38,43 have this issue.
    Could you please look into it?
    Additionally- how do I attach the file while I reply?

    Regards,
    SSP

+ 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. [SOLVED] Count days in a rolling 12 month period
    By mlafrance in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 09-30-2023, 07:45 AM
  2. Count Number of Days, In a rolling 12 month period
    By ExcelNewbie1977 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 12-19-2016, 03:29 AM
  3. Count days per month within a period
    By Cunner in forum Excel General
    Replies: 4
    Last Post: 02-03-2014, 06:12 AM
  4. Count number of networkdays for each month in a multi month period
    By dreddster in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 05-10-2013, 11:12 AM
  5. Remove missed days after 12 month rolling period
    By gopherc4 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-21-2009, 06:12 PM
  6. Calculating number of days in each month during a given period.
    By josnah in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-28-2007, 02:52 AM
  7. [SOLVED] Days in month for 10 year period
    By Geoff in forum Excel General
    Replies: 4
    Last Post: 05-06-2005, 12:06 PM

Tags for this Thread

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