For us to subtract months from a given date in excel, we use the function EDATE. The next step in this procedure will be to subtract a couple of months in a given set of dates. Open a new excel sheet and record your data in it. We can use the following procedure with examples to guide you in the activity of subtracting the number of months you need to.Ĭome up with a data set where you will need to backtrack in months. Subtracting months from the current date is just one of the ways you can backtrack in an excel sheet to get some relevant data from that particular date. With date also you can easily trace a particular set of data or a cell because you will sort the entire data by date. We use dates in excel to keep a good track of the time when our records were created and recorded. In excel sheets you can record time, date, schedule events and activities, keep a record of items and their prices, and many more.Īny type of data we wish to record or record in Excel sheets is time-dependent even though we may not include tome in all the records, but dates will always remain a vital aspect. Excel sheets nearly store all types and sorts of data that we happen to interact with within our day-to-day life activities.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |