RockandGrohl
Well-known Member
- Joined
- Aug 1, 2018
- Messages
- 790
- Office Version
- 365
- Platform
- Windows
Sorry guys, my google-fu is failing because it keeps thinking I want to either find the last day of the month, etc.
Anyway, in column A I have a list of dates, 01/01/2023, 03/01/2023, 05/01/2023, 06/01/2023..
How do I return "6" - as in, 6 is the last day of that string of dates.
I could do this - is there a more elegant way?
Thanks!
Anyway, in column A I have a list of dates, 01/01/2023, 03/01/2023, 05/01/2023, 06/01/2023..
How do I return "6" - as in, 6 is the last day of that string of dates.
I could do this - is there a more elegant way?
Excel Formula:
=MAX(CDR!A:A)-DATE(YEAR(CDR!A2),MONTH(CDR!A2),1)
Thanks!