","title":"Excel","shortTitle":"Excel","parent":{"__ref":"Category:category:microsoft365"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:gxcuf89792"}},{"__typename":"Cor...
Calculating the RATE as the similar financial function in Excel - SQL Server 2014-2016 Call a webservice from TSQL (Stored Procedure) Call function from view Call function on Linked server Call getdate from linked server call the multiple .sql files through Batch script Calling the same function...
"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumTopicMessage:message:3756522"},"conversation":{"__ref":"Conversation:conversation:3756522"},"subject":"Re: How can I calculate anniversary date (10, 20, 3...
Calculating the RATE as the similar financial function in Excel - SQL Server 2014-2016 Call a webservice from TSQL (Stored Procedure) Call function from view Call function on Linked server Call getdate from linked server call the multiple .sql files through Batch script Calling the same function...
{"boardId":"excelgeneral","messageSubject":"how-can-i-calculate-anniversary-date-10-20-30-40-50-and-etc--","messageId":"3756522","replyId":"3756543"},"buildId":"cQon2PUqbQU8la6pXifn2","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","log...
"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumTopicMessage:message:3756522"},"conversation":{"__ref":"Conversation:conversation:3756522"},"subject":"Re: How can I calculate anniversary date (1...
Calculating 30,60,90 Days Totals in sql Calculating Average between two datetime columns Calculating the RATE as the similar financial function in Excel - SQL Server 2014-2016 Call a webservice from TSQL (Stored Procedure) Call function from view Call function on Linked server Call getdate from...
Excel Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visitMicrosoft Support Community. turan_aghayev Copper Contributor Mar 02, 2023 question.xlsx9 KB SergeiBaklan ...
=LAMBDA(birth_days,number_of_anniversaries,BYROW(birth_days,LAMBDA(row,TEXTJOIN(", ",,TEXT(DATE(YEAR(row)+SEQUENCE(,number_of_anniversaries,10,10),MONTH(row),DAY(row)),"m/d/yyy"))) The Anniversary function. Provide the birthdays and tell it h...