Hello
I can't make work the formula =days on google spreadsheets
I'm adding and deleting alot of lines, so i can't have 2 specific cells to count
I want to count on A2 the dates between A3 and A9999
Please Login or Register to view this content.
Any soul available to help me?
Last edited by Web-Man; 02-15-2022 at 06:18 AM.
If you are just counting dates, try =countA()
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
It shows me 17 :sOriginally Posted by FDibbins
Attachment 767727
from your data, and your responses, it seems you want count of the number of unique dates in column A.
so the formula should be:
Screen Shot 2022-02-12 at 1.46.18 am.pngPlease Login or Register to view this content.
While i type, i see others also working, so to counteract, you can use this in Google Sheets:
Please Login or Register to view this content.
Last edited by janmorris; 02-11-2022 at 03:11 PM.
Thank you @janmorris , but i need to count on A2 the number of days between A3 and A9999
Because i will add hundreds of new lines
please see new edit, and you can adjust to be:
this will give you unlimited new rowsPlease Login or Register to view this content.
NOTE: you can NOT put the formula in the same range you are trying to sum the unique values.. that is just plain @#$%id
Last edited by janmorris; 02-11-2022 at 03:00 PM.
It is working now for the old list janmorris
But i added new days from January and is not working properly
if you want the actual days between the earliest date and the latest date, then use:
Please Login or Register to view this content.
Thank you janmorris , thats it!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks