## Convert date field into text in Excel

I have an Excel file which has a column formatted as date in the format dd-mm-YYYY.

I need to convert that field to text. If I change the field type excel converts it to a strange value (like 40603).

…

Technical knowledge for tech readers and developers

worksheet-function

I have an Excel file which has a column formatted as date in the format dd-mm-YYYY.

I need to convert that field to text. If I change the field type excel converts it to a strange value (like 40603).

…

I currently have an excel worksheet similar to the following (#’s represent blank cells)

1 2 3 4 5 6 7

37 21 30 32 25 22 34

# 17 26 28 27 17 31

# # # # # # 38

25 …

I use the following function

=DAYS360(A2, A35)

to calculate the difference between two dates in my column. However, the column is ever expanding and I currently have to manually change ‘A35’ as I …

I have worksheet where I need named ranges to correspond to the contents of another cell. The text in the cell is something like:

Partitions w Studs 16″ oc

Named ranges cannot have spaces, or most …

I am trying to find first highest number and second highest number in excel. What shall i do for that. I did not find the right formula.

Note: I have already used the large and max formula.

=LARGE(…

I have an interesting challenge – I need to run a check on the following data in Excel:

| A – B – C – D |

|——|——|——|——|

| 36 | 0 | 0 | x |

| 0 | 600 | 700 |…

I am trying to create a spreadsheet which automagically gives a grade to a student based on their marks they got.

I’ve apparently hit Excel’s nested IF statement limit which is 7.

Here’s my if …