![]() You can subtract numbers with a cell, numbers in two cells, and numbers in multiple cells. The formula to break this down to months would be:Īnd, of course, you can break it down even further by dividing it all by 365. Most of the subtraction in Excel is done with ‘-‘ and ‘’ operators. ![]() To avoid having to do some mental math, you can take that formula and divide it by 30 to approximate months. This, unfortunately, only gives you the number of days between today and the project start date. Excel has a TODAY function built in, which will save you from typing in the date in the correct format and continually updating as the days change. What’ll you need to do is subtract today’s date from the project start date. ![]() Let’s say you have 10 active clients, and you are wondering how long each of them has been on your roster.Īnd you are curious how many days, weeks, or months each client has been active in your roster (assuming the above dates are accurate). That said, since you need to track when certain things happened in HMIS, it’s helpful to learn how to deal with some of the date functions in Excel in the course of tracking things.įor this post, though, we’re just going to learn how to compare a date to today. Dates can be tricky to deal with in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |