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...
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...
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...
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...
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...
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
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...
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.
current date = 4th July 2016(ie a Monday) = result 1st July 2016 (ie previous Friday date)
current date =...
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:
Is it not possible to use the...
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...
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.
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...
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...
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...
I have a range filled with dates as such:
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...
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
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
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...
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()
If TODAY() = (TODAY() - Day(TODAY()) + 32 - Weekday(TODAY() - Day(TODAY()) - 1)) Then
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.