filmov
tv
DAY Formula in Excel | How To Use DAY Function in Microsoft Excel | Bangla tutorial
Показать описание
Microsoft Excel's Text function can help you to convert date to its corresponding month name or weekday name easily. In a blank cell, please enter this formula =TEXT(A1,"mmmm"), in this case in cell C1. , and press the Enter key. And then drag this cell's AutoFill handle to the range as you need.
Calculating the number of days using Excel is pretty simple. Just use a formula to subtract the later date from the earlier date. For example, if cell A1 contains 1-Jan-2004 and cell A2 contains 03-Mar-2004, you simply enter the formula =A2-A1 in cell A3 to get the number of days.
all excel formula, all excel formula and function, all excel function
Calculating the number of days using Excel is pretty simple. Just use a formula to subtract the later date from the earlier date. For example, if cell A1 contains 1-Jan-2004 and cell A2 contains 03-Mar-2004, you simply enter the formula =A2-A1 in cell A3 to get the number of days.
all excel formula, all excel formula and function, all excel function
0:00:16
0:00:15
0:00:20
0:02:17
0:00:12
0:02:16
0:00:17
0:04:29
0:00:37
0:01:18
0:00:23
0:00:11
0:00:37
0:00:19
0:03:53
0:00:20
0:00:35
0:00:53
0:00:14
0:00:43
0:00:15
0:00:20
0:00:25
0:00:11