today()

  1. K

    If isblank today()

    Greetings to Tech Gurus, I'm seeking help in nesting a formula but ending up with an error. Please see below details for my formula nesting. C3= % (this cell will have number up to 100 in %) F3= Date (this cell will have date in MM/DD/YYYY format) G3= formula (below is the formula which i'm...
  2. E

    Hyperlink Mailto with If and OR and Today() Functions

    Hi Everyone! I know I'm close but I've hit a brick wall. I have a form where users fill it out and submit via email. There is a Hyperlink Mailto cell (O12:V15) that I want them to click and it generate an email with proper subject depending on cells within the form. Here's what I have already...
  3. zakasnak

    conditional formatting questions

    I have a spreadsheet (duh!) that uses dates for nominations of natgas. On Monday, I nom for Wednesday (highlighted), on Tuesday, I nom for Thursday (highlighted), etc. The problem comes when today's date is a Thursday, I want the conditional formatting to highlight Saturday, Sunday, AND Monday...
  4. J

    Counting Blank Cells using TODAY()

    Hello all, I have a spreadsheet that I am trying to count the number of days in one column from last entry to TODAY(). I have a date column and then a second column that has delivery amounts. This second column is ONLY used when a delivery is made. I would like to count the number of days...
  5. G

    Change formula to include rows less than today's date

    Hi All, I have this formula which was provided to me and sorted one problem out which was great. Now I need to adapt the formula so that instead of excluding rows with today's date, I want it to now only include rows with today's date. How do I adapt this formula so it is only including the...
  6. R

    Trying to use Today() function in an IF loop

    I'm attempting to delete rows with dates beyond tomorrow's date with the following code: Do While Not IsEmpty(ActiveCell) If ActiveCell.Value = TODAY + 1 Then Selection.EntireRow.Delete Shift:=xlUp Else ActiveCell.Offset(1, 0).Select End If Loop End Sub It doesn't...
  7. J

    Today or Before Conditional Formatting

    I am having a problem with conditional fomatting. I have created a rule "=$I$14<=TODAY()" which does exactly what I want to do. My issue is when I apply this same rule to a number of cells "=$I$4:$I$66<=TODAY()" it will either format all or none. It will not format each cell individually...
  8. N

    IF, TEXT and TODAY() VBA statement

    Hi all, within a macro I am trying to apply an IF statement to a cell. Basically IF the current date = Monday then return the date from 3 days prior, else display date 1 day prior. eg: current date = 4th July 2016(ie a Monday) = result 1st July 2016 (ie previous Friday date) current date =...
  9. T

    Countif for between today and the end of the month

    Hi there, I'm trying to count all the cell that fall between the current day's date and the end of the month. I've been trying this formula and similar iterations to no luck: =COUNTIFS('Milestones'!J:J,">=Today()", 'Milestones'!J:J,"<=EOMONTH(TODAY(),0)") Is it not possible to use the...
  10. M

    Verify Date Then Calculate Sum Last 7 Days

    Hey Guys, I am wanting to setup a part in my spreadsheet that will display today's date then calculate certain data in relation to the date. For example: Date: 16/04/16 (I need Excel to automatically fill this, will Today() work?) The sum of all values for the last 7 days: 127 (I need Excel to...
  11. N

    How to keep NOW() and TODAY() From updating.

    So, I need to keep the NOW() and TODAY() from changing every time I change a cell or open the spreadsheet. I need the columns C, (TODAY()), F and G (NOW()) to stop updating once there is a time or date in the column. Thank you for the help! If you need anymore information Let me know.
  12. S

    Combining either VLOOKUP or INDEX-MATCH with Today()

    Hello, In Sheet 1, I have to pull a value in H4 where we look up the value in B4 within Column A in Sheet 2. However, I don't want to specify a constant column number within Sheet 2 to return the value, like we would for a standard VLOOKUP. The value I want to return in that Column H cell needs...
  13. E

    Date prior to today with conditions

    Hi all, I have the following data: Column A: Projected completion date (normal format DD/MM/YY) Column B: Project status (either "active" or "inactive") I want to use conditional formatting to highlight a date prior to today but only if the project status is "active". I know the formula for...
  14. B

    Automatic Date Based Formulas Without VBA

    So I now have a small business that uses cash accounting. Since I don't need much in the way of accounting, I use an Excel workbook for the numbers. Overtime I needed to see sums and averages based on time--7 days, 30 days, etc. To accomplish this, without using the dreaded--for me--VBA, I used...
  15. C

    VBA countifs date less than today's date?

    Dear all, I have a range filled with dates as such: <tbody> A 1 Date 2 01/07/2015 3 4 01/08/2015 5 01/09/2015 </tbody> I am planning to use Worksheetfunction.countifs to count the number of dates that are smaller than today's date as one criteria. In excel this would have been...
  16. T

    TODAY () - START DATE = X. but if CELL ROW = "Yes", stop the counter and take the value. If cell = "No" continue date formula

    Hi All, As the subject suggests... TODAY () - START DATE = X. but if CELL ROW = "Yes", stop the counter and take the value. If cell = "No" continue date formula G2 = TODAY() The START DATE is in column F9:F100 The count between TODAY() and the START DATE is shown in columns K9:K100 If columns...
  17. M

    Help w Today() + Text excel vba

    My code looks like this ActiveCell.FormulaR1C1 = "CHARGES 03/23/15" I would like to run my vba code daily for a daily report, so I need the macro to input something like "TODAY()" e.g. today's date. How can I combine "CHARGES" with the date on the same cell? ty
  18. O

    Suming and Subtracting

    Hey guys, I need some help. I need a formula that, sum from I7:I1000 if the cells A7:A1000 are filled with "RL1", and G7:G1000 are filled with TODAY() date, but i need to subtract the value of I7:I1000 if the cells J7:J1000 are filled with "OK". I don't know how to do that and I've been trying...
  19. A

    VBA Code that backups when opening worksheet

    Hi I have written a VBA code that backups the excel worksheet on the 3rd monday of the month but it doesnt work and i doing something wrong. Private Sub Workbook_Open() 'Backup If TODAY() = (TODAY() - Day(TODAY()) + 32 - Weekday(TODAY() - Day(TODAY()) - 1)) Then ChDir _...
  20. P

    Date formula returns 1902?

    Hi, I am just doing a quick date formula to find an invoice date. Basically I have the Due Date in column A1 and in B1 I have the formula ... TODAY()-A1 ... but this returns 22/01/1900? Can anyone explain a quick fix for this? What am I doing wrong?? Thanks in advance for any help.

Some videos you may like

This Week's Hot Topics

Top