I want a formula to list in range A11:A16 the list of months starting from the current month to the month on date B6 at the same time it should not include the month mentioned on the date in B6 only incase the date in B6 starts with date first. e.g if date in B6 is 01-10-2023 (First Of October 2023) then October should not be part of the list in range A11:A16
test.jpg
Copy of 001369.xlsx
a11:
=EOMONTH(TODAY(),-1)+1
A12, copied down:
=IFERROR(IF(EDATE($A$11,ROWS(A$12:A12))>=$B$6,"",EDATE($A$11,ROWS(A$12:A12))),"")
format all cells as mmmm. It also works over year ends, as shown in the sheet (I added a few more rows)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
brilliant brother thank you so much, as usual, amazing result
working perfectly thank you againOriginally Posted by MAJID1479
You're welcome!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks