Check Count of Buildings Until Day 1 of Every Month

**raksone** · 06-23-2022, 09:29 PM

Hello community!

I have been trying to solve this problem for hours but have not been able to reach the desired result.

What I want to do, is, to determine the amount of Buildings available until the first day of each month. For this, I have to measure how many "first day (i.e. 1/1/2022 - 2/1/2022)" fall within a date range and based on that, add up the amounts of the building that were active on each month of a all applicable years.

There are some buildings that are still available while others are no longer.

I have been trying to reach the result by doing different formulas, so don't pay much attention to what I have accomplished so far

I attach the file for your reference.

Thank you!!

**Gregb11** · 06-23-2022, 11:29 PM

Maybe in D3 try:

=YEAR([@[End Date]])-YEAR([@[Start Date]])-IF([@[Start Date]]>DATE(YEAR([@[Start Date]]),MONTH(1&D$2),1),1,0)+IF(MONTH([@[End Date]])>=MONTH(1&D$2),1,0)

Copy (don't drag) across.

Check Count of Buildings Until Day 1 of Every Month

LinkBack

Thread Tools

Rate This Thread

Display

Check Count of Buildings Until Day 1 of Every Month

Re: Check Count of Buildings Until Day 1 of Every Month

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] how to calculate count & percentage form data base based on current month & previous month

VBA to copy data across a range based on the number of buildings required

[SOLVED] VBA to replicate a range of cells based on the number of buildings required

Finding Vacancy Percentage Month Wise from Check in and Check out Date

Not the most efficient at this better off suited constructing buildings

How to check if month in column B is before current month

Combining two spreadsheets to check for changes from month to month

Bookmarks

Bookmarks

Posting Permissions