Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
W
W
winzerofox2016-12-21 19:15:44
excel
winzerofox, 2016-12-21 19:15:44

Calculate day and month in non-leap year from day number?

Calculate day and month in non-leap year given day number?

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
A
Anton Fedoryan, 2016-12-22
@winzerofox 

=СЦЕПИТЬ(ДЕНЬ(ДАТА(A2-1;12;31)+B2);" ";ТЕКСТ(ДАТА(A2-1;12;31)+B2;"ММММ;@"))

afe968c93e4d4e0eb97b5e0e7cc31669.png

Similar questions
D
Danil O'neil2021-02-17 19:34:02
Excel places the artifacts on top of the cell. What is it and how to remove it? 2Reply
M
Madiyar Lacroa2015-02-13 12:49:23
How to plot a histogram in Excel 2010? 1Reply
L
LightSid2017-02-17 15:06:07
How to export all days from analytics? 1Reply
S
skullcowboy2017-02-18 11:13:11
In the Mac version of Excel 2016, the colors of the cells are not copied, only the data in them. How to solve it? 0Reply
A
Andrey Demidenko2015-02-23 15:19:51
Which gem to use to parse an excel file into an Active Record object? 1Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question