Results 1 to 8 of 8

Count of Days per month for a contract period

Threaded View

  1. 12-14-2020, 06:27 AM #3
    Shareez Saleem
    Shareez Saleem is offline
    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
    Reply With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1