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

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)

A

Anton Fedoryan, 2016-12-22
@winzerofox

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

Similar questions

2

20bez2018-11-07 11:42:15

How to create a service based on geodata? 4Reply

L

le1872018-11-15 14:05:58

Excel spreadsheets were damaged or incorrectly restored. How to fix? 3Reply

E

EnZo_Smile2016-06-17 12:41:51

How is it more convenient to implement the check for the presence of an input value in Excel? 1Reply

H

hitakiri2014-05-13 13:30:51

How to transfer from MS Excel to remote server with PHP? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question