Question

a) How to countd the total number of days between two specified dates ?
b) How to count the total number of characters (length) of secified string ?

Answer 1

!!•••••••☆☆ $<b >Hey mate$ ☆☆•••••••!!

$\color{Red}{ \boxed{\bold{ \underline{Number..Specified..Dates}}}}$

In the above formula B2 indacates the end data and B1 indacates the start date.

You can replace them as your need.

$\color{blue}{ \boxed{\bold{ \underline{Number..Character}}}}$

•To use the function, enter =LEN(cell) in the formula bar and press Enter. ...

•To count the characters in more than one cell, enter the formula, and then copy and paste the formula to other cells.

•To count a total number of characters in several cells, use the SUM functions along with LEN.

☆☆☆☆• Hope Help u •☆☆☆☆

Answer 2

Explanation:

Type the holiday dates into the cells that you want to subtract from the dates, Then enter this formula =NETWORKDAYS(B1,B2,B3:E3), (B1 indicates start date, B2 stands for end date and B3:E3 is the list of holidays) then press Enter key, the number of workdays which not include Sundays, Saturdays and holidays have been ...