Are you stuck with calculating how many days there are since a certain date or until date? This tutorial will teach you an easy way to add and subtract days from date in Excel. With our formulas you can quickly calculate 90 days from date, 45 days before date, and count whatever number of days you need. Continue reading
Comments page 2. Total comments: 75
can please tell me which formula I should use on 12-Feb-2022.
now I need number 28 days
Hi!
Sorry, it's not quite clear what you are trying to achieve.
I have days and time in a column..I need to count how many are less than or equal to 3 days? How many are greater than 3 days and less than or equal to 5 days?
Please provide formula..To get count.
Thank you
Hello!
Here is the article that may be helpful to you: COUNTIF formulas for dates.
I don't know how your data is written so I can't give an example formula
Kindly help to below table no of days calculation. incase between dates are missing last date minus before date.
sample table below mentioned required all results in one formula.
date 1 date 2 date 3 date 4 date 5 date 6 Ans
01/01/2022 03/01/2022 08/01/2022 17/01/2022 21/01/2022 23/01/2022 2
01/01/2022 03/01/2022 08/01/2022 23/01/2022 15
01/01/2022 23/01/2022 22
01/01/2022 03/01/2022 08/01/2022 Nil
01/01/2022 17/01/2022 21/01/2022 Nil
01/01/2022 03/01/2022 08/01/2022 17/01/2022 21/01/2022 Nil
Hi!
What do you want to calculate exactly? Your question is not entirely clear, please specify.
THANKS, A LOT FOR YOUR LESSON ON THIS MEDIUM.
I NOW USE THIS FORMULA AND IT IS WORKING GOOD
IF(TODAY()-A2<1,"", IF(TODAY()-A2<=28,"POTENTIAL LOSSES", ""))
I have this formula problem.
The issue am have is as follow.
Cell A2 contain next appointment date (7/13/2021). If a client missed the appointment day he will become POTENTIAL LOSSES for the next 28 days after the appointment day and on the 29th day he become LTFU( Lost to follow up).
I used this formula =IF(TODAY()-A2<=28,"POTENTIAL LOSSES","")
it is returning even future date such as 8/30/2021 as "POTENTIAL LOSSES" where as it should give it as Blank cell and it is not even return "POTENTIAL LOSSES" a day after missing the appointment date whereas it should return "Potential losses" till 28th day and change to lost to follow up on the 29th day.
How do you use the future date in the formula? Where do you insert it? The TODAY function returns today's date. If you use a cell with the date 8/30/2021 instead of TODAY, the formula returns "".
Hello!
Formula = IF(TODAY()-A2<=28, "POTENTIAL LOSSES", "") returns "POTENTIAL LOSSES" for me. It works correctly.
Thank you for your reply. The problem is the future date from today is returning as POTENTIAL LOSSES which should return BLANK-like 29 days after the appointment day. I don't know what is the cause, sir. I will appreciate it if you run it and put future say
13/8/2021 in A2 and see what it will return.
Want to calculate no. Of days with TRUE or FALSE if days is more then 7 day's after week off or holiday...what formula need to write
I want to work out a date in the past from a certain date and certain number of days before or after. So I want the date 15 days before a specific date, but I do not want to add the Sunday, the public holiday and the school holiday. So I have the calendar for the year, a day is assigned a zero or a 1. All days on which the school will be open as well as a Saturday will be a 1. Any other day on which there will not be school like a school holiday, Sunday or public holiday will be a zero. I am missing something here. PLease assist, thanks
Hello!
Please check out the following article on our blog, it’ll be sure to help you with your task: Excel NETWORKDAYS.INTL function
You can calculate the number of days between two dates, taking into account the weekend. You can also use your own list of weekends and holidays.
I hope it’ll be helpful.
Hello,
I need to calculate days till something is due and then continuing counting how many days overdue (e.g. -3 days late). I have a formatted the due date and then in the column overdue what formula do i put?
30 days late on payment and I want to make it update each date they are late.
Ex: 30days late making the next day(s) go up each day automatically So I don't have to do it myself each day
Hello Harry!
I’m sorry but your task is not entirely clear to me.
Please describe your problem in more detail. Write an example of the source data and the result you want to get. It’ll help me understand it better and find a solution for you. Thank you.
Hi: is there a modification to use to exclude holidays when calculating workdays using this formula:
=workday(A1, -2)
Hello Kelly!
You can learn more about calculating weekdays in Excel in Excel in this article on our blog
https://www.ablebits.com/office-addins-blog/excel-workday-networkdays-functions/
Use function WORKDAY.INTL.
Hope you’ll find this information helpful.
Bonjour,
J'aimerais trouver une formule pour calculer le nombre de jours depuis une date jusqu'aujourd'hui, SVP.
Je n'ai que la date entrée donc les formules de DATEDIF et DATEVAL ne peuvent pas marcher.
Ex: j'ai un dossier de 2017 qui n'est pas fini, que dois-je faire pour avoir le nombre de jours à partir de 2017 jusqu'aujourd'hui?
I want to kiss the person who wrote this article.
you made my life much simpler than it already is haha.
Thanks a lot
HI,
Would like to calculate the due days based on the present days.
What is the date four days before November first 2018 without counting the weekend
Hi Brenda,
The below formula says it's October 26, 2018:
=WORKDAY("1-Nov-2018", -4)
Please remember to apply the Date format to the formula cell for the result to display correctly.
I NEED A EXCEL FORMULA TO calculate 15 days free storage
I have a monthly report but need to count only daily data. I don't know to use Today option if formula is =COUNTIF(A1:A50,"Vacation")=TODAY(). Please help
IvTe:
If you can use COUNTIFS in your version of Excel then I believe this formula is what you're looking for.
=COUNTIFS(A1:A50,"=VACA*",B1:B50,"<="&TODAY())
Where the word "VACATION" is in A1:A50 and the Date is in B1:B50. Note this formula uses a wildcard so "Vaca" is counted, too.
You can change the addresses to suit your needs.
1982-2014 CSRC.2015.007
Svetlana Cheusheva, thank you for this post. Its very inspiring.