Finding the number of times a date shows in a column for each date and entering values

**ija34** · 08-27-2022, 11:34 AM

Hey all,

Okay, so I have 2 separate sheets in a workbook and on one of these sheets I have a table with dates that show up more than once in the table but on the same column. On the next sheet I have a table with the same date range from the previous sheet but I only have these dates once in the column. What I want to do is go to the other sheet, find the number of times a date shows up in this column up to the last row and then go back to the other sheet and input this in the next column next to the specific date (dates are in order on this sheet). I have tried testing bringing back the number of times the date shows and put it in a cell but seem to just get "0". Copied the code below so you guys can see. Cheers.

Please Login or Register  to view this content.

**TMS** · 08-27-2022, 11:43 AM

Maybe try the American format, "08/25/2022"

**ija34** · 08-27-2022, 11:53 AM

That works for some reason, can you explain why the American format works even though both sheets are in UK format? So, now I need to do the same but it needs to find the values by cell ID and do it all in one go. So one click of the button will find all the dates from sheet 2 in sheet 1 and enter the number of times it shows in sheet 2.

**TMS** · 08-27-2022, 12:28 PM

VBA is American oriented. Personally, I wouldn't do the calculation in VBA. I'd just drop a COUNTIF formula into the relevant cells and then convert to values.

**ija34** · 08-27-2022, 12:37 PM

The workbook needs to be fully automated and mostly operates on buttons so needs to be VBA. Because of the amount of data it will contain, I need to reduce the manual input as much as possible.

**ija34** · 08-27-2022, 02:01 PM

Done! Had to convert the dates to American format. Code below.

Please Login or Register  to view this content.

**TMS** · 08-27-2022, 03:33 PM

And why would it not be?

Please Login or Register  to view this content.

No loop

. Fully automated. Formulae to Values.

Finding the number of times a date shows in a column for each date and entering values

LinkBack

Thread Tools

Rate This Thread

Display

Finding the number of times a date shows in a column for each date and entering values

Re: Finding the number of times a date shows in a column for each date and entering values

Re: Finding the number of times a date shows in a column for each date and entering values

Re: Finding the number of times a date shows in a column for each date and entering values

Re: Finding the number of times a date shows in a column for each date and entering values

Re: Finding the number of times a date shows in a column for each date and entering values

Re: Finding the number of times a date shows in a column for each date and entering values

Thread Information

Users Browsing this Thread

Similar Threads

Retrieving date field shows date as a number, why?

[SOLVED] Sum times a given date shows on a new column, per date!

[SOLVED] formula for counting number of times a date shows in a cell that contains other info

[SOLVED] when entering into one box it automaticly shows in another box the date & time it was ente

[SOLVED] Date Field in the Userform shows a number and not the date - Solution?

Copy column variable number of times between start date and end date

Excel: I enter date and format for date, but shows as number

Bookmarks

Bookmarks

Posting Permissions