User Profile

CA-Santosh

Copper Contributor

Joined Apr 08, 2020

2 Posts2 LikesLikes received

View All Badges

User Widgets

Recent Discussions

Re: Generating af list in a cell
JonasRKorsholm Hi, You can try the below formula =CONCAT("Employees:",SUBSTITUTE(TEXTJOIN("-",TRUE,FILTER($A$2:$B$100,$A$2:$A$100=A2)),A2,"-")) Attached file contains the above formula
Apr 15, 2020 Place Excel
2.1KViews
1like
10Comments
Re: Auto monthly due date update
Hi, Try this formula - =DATE(YEAR(A2),IF(DAY(A2)<=15,MONTH(A2),MONTH(A2)+1),15) Assumption made: 1. Bill date (from the 1st day of month to 15th day of month) - Due date falls on 15th day of the same month 2. Bill date (from the 16th day of month to month end) - Due date falls on 15th day of the next month 3. Assume A2 cell contains the Bill date.
Apr 12, 2020 Place Excel
6.7KViews
1like
2Comments

Recent Blog Articles

No content to show