AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
How do you find a range in excel4/8/2023 ![]() In this example, we wish to combine the two dates as a date range in a single cell with a different format, say “d mmm yy.” So the formula for a date range, in this case, would be as follows:ĭate Range =TEXT(A3,”d mmm yy”) & “-” & TEXT(B3,”d mmm yy”) The ampersand ‘&’ operator is used to concatenate the two dates as a date range in a custom format, specified as “mmm d” in this case, in a single cell, and the two dates are joined with a hyphen ‘-‘ in the resultant date range which is determined in cell C2. The TEXT function receives the dates stored in cells A2 and B2. So we can see in the above screenshot that we have applied the formula in cell C2. This function receives two date values as numeric and concatenates these two dates in the form of a date range according to a custom date format (“mmm d” in this case):ĭate Range =TEXT(A2,”mmm d”) & “-” & TEXT(B2,”mmm d”) The general syntax for this formula is as follows: For doing this, we can use a formula based on the ‘TEXT’ function can be used. Now, suppose we have two dates in two cells, and we wish to display them concatenated as a date range in a single cell. So we can see that using the date ranges in the first two rows as a template, Excel automatically creates date ranges for the subsequent rows.
0 Comments
Read More
Leave a Reply. |