Comments on: Calculate and highlight 90/60/30 days from or before today in Excel

Comments page 2. Total comments: 54

1. 

   Vishak says:
   2019-03-29 at 2:25 pm

   I have a bug open for 100 days and I want to add it in the bucket( 30-60days), (60-90 days)
   How to achieve it in google sheets

2. 

   Rosalina says:
   2019-03-22 at 8:55 pm

   Hello,
   Does anyone know how I can use Conditionnal Formatting in Google Sheets to auto highlight the current date ?
   Lets say I enter a deadline as 22/03/2019 on that specific date I would like the cell to turn into a specific colour.
   Please contact me if you have information on the topic. Thanks alot!

3. 

   Tracy says:
   2019-02-19 at 8:56 am

   How do I highlight the below in red 30 days before the dates shown?
   5 yearly
   "Electrical
   Test"
   30.04.23
   01.09.19
   01.09.19
   01.08.19
   01.08.19
   24.01.21
   01.09.21
   01.07.22
   28.03.23
   01.12.22

4. 

   Mike says:
   2019-02-18 at 4:10 pm

   I have a set of 4 dates set at three months apart through the year, I want them to turn Amber when the (TODAY) date is in the same month, and then turn RED if the date passes.
   Is this achievable?

   Thanks in advance

   Mike D

5. 

   Giri prasad says:
   2019-02-07 at 3:46 pm

   Hi
   I need calculate sum if bill age b/w 1-30, 30-60, 60-90 etc...
   Net pay Date Ageing
   79500 18-Sep-11 2699.00
   54500 20-Jan-19 18.00
   14500 14-Sep-18 146.00
   13500 10-Dec-18 59.00
   64500 16-Jan-19 22.00
   9000 10-Jan-19 28.00
   24500 10-Nov-18 89.00
   22500 10-Nov-18 89.00
   21500 10-Nov-18 89.00
   74500 10-Jul-18 212.00
   34500 10-Jul-18 212.00
   34500 10-Jul-18 212.00

   Below 30 Below 30-60 Below 60-90

   Hope u can help reg this
   Thanks & Reg
   Giri prasad

6. 

   Cristal De La Torre says:
   2018-12-17 at 9:48 pm

   Hello,
   I am trying to have column F to turn red if it is past 30 days of the date in column E which will have a date or NO. I've red several forums need help :(
   thank you!
   Cristal

   1. 

      Mary Trifuntova (Ablebits Team) says:
      2018-12-18 at 9:34 am

      Hello, Cristal,
      It looks like you need to set the conditional formatting rule to solve your task. Please have a look at the following article on our blog:
      How to conditionally format dates and time in Excel

      Hope you'll find this information helpful.

7. 

   Samuel says:
   2018-11-28 at 2:55 am

   I want to populate my timesheet with the correct date for each day that updates automatically, picks the month in words automatically in a different cell.

8. 

   Sagar says:
   2018-10-25 at 12:10 pm

   I need Employee business before 30 of training date & after 30 days of training date.

   i.e. If my Employee training date is 15th Oct, so i need before 30 days of business (14th Sep to 15th oct)& after 30 days of business (16th Oct to 15th Nov)

   Which formula I can use for above query.

9. 

   Ugi says:
   2018-08-29 at 8:36 pm

   Hi, How can add amounts based on 30+ days from origination?

10. 

    Tr says:
    2018-08-22 at 6:23 pm

    Hi,

    How would I use data validation to calculate a start and end date that must fall -90 days from todays date and be in the current year. The date has to be in current year even if the prior year falls within the -90 back from today whatever today will be?

    regards

11. 

    Carlos A Ibarra says:
    2018-07-25 at 7:43 pm

    Hi, How can add amounts based on 30+ days from origination?

    Date Amount
    Draw 1 6/1/18 500.00
    Draw 2 6/15/18 500.00
    Draw 3 7/1/18 500.00
    Draw 4 7/15/18 500.00

    Since June 1 and 15 have more than 30 days from today 7/23/18 the result should be 1,000.00

    I have tried many different ways with no success, any help will be appreciated.

    Thank you,
    Carlos

12. 

    Doug says:
    2018-07-17 at 12:32 pm

    SHYNI:
    Excel will calculate future dates using this formula:
    =DATE(YEAR(H4)+2,MONTH(H4)+5,DAY(H4)+3)
    This will return 12/28/2020 from your sample date.
    To return 10/23/18 or 90 days from your sample date use this: =DATE(YEAR(H4),MONTH(H4),DAY(H4)+90)
    You might be tempted to enter a "+3" in the month spot, but if you do Excel will return 10/25/18 from your sample date. So, three months is not the same thing as 90 days in Excel date calculations.
    Be sure the date you enter is in a format Excel recognizes as a date and that the cells you use in these calculations are formatted as dates.
    Play around with this formula and you'll quickly see how to use it.

13. 

    SHYNI says:
    2018-07-17 at 6:35 am

    ARRIVAL DATE : 25.07.2018

    WHAT IS THE FORMULA FOR FINDING 90 DAYS FROM THE ARRIVAL DATE

14. 

    Sudheesh says:
    2018-04-30 at 12:29 pm

    Hi Svetlana,

    If total 85000 then rates as per below slab
    0 to 40000 (40000 x 0.50)
    40001 to 80000 (40000 x 0.45)
    (balance 5000 x 0.425
    how to get the formula in one cell (total), please advise the formula.
    Thanks.

    1. 

       Mikey says:
       2018-05-02 at 9:13 pm

       nested if will do the trick:

       =IF(A1<=40000,A1*0.5,IF(A1 19500
       45000 --> 22250
       85000 --> 40125

       1. 

          Mikey says:
          2018-05-02 at 9:15 pm

          code got eaten. if you see $lt; below, that is less than symbol.

          =IF(A1<=40000,A1*0.5,IF(A1<=80000,SUM(20000,(A1-40000)*0.45),SUM(38000,(A1-80000)*0.425)))