not been on here for a while and am very rusty to say the least
i have 5 consecutive cells say b1:f5 each cell has a date in each date is later than the previous one
when b1 matches todays date then format red
when c1 matches todays date then format yellow and b1 to go back to no...
I have a spreadsheet with a list of loans. I want to calculate the number of months that a loan interest payment is late if it's not yet reached maturity, or the number of months interest was unpaid if the maturity date has already passed. And, if there's nothing late, then leave the cell...
I am doing project management and schedule planning and am looking for method of easily highlighting cells when something is overdue or soon-to-be-due.
To simplify my question, say I have two columns, one with date's (expected task finish date) and one with % complete:
I am trying to find a code that will work to change sheet tab color to red if a cell in a different sheet has a date that is less than today's date in it.
Ex. Column H in Sheet1 has registration dates in it, Sheets2-30 have vehicle information in them.
Sheet2 tab turns red if the date in H1 of...
formula needs to:
compare date in one cell to that of another, and if that date is greater by 30 days than that date, then true.
My previous formula was similar to this, but it just looked at today's date and if that was greater than 30 days, then it was true.
But now I need that same formula...
I am hoping you could help me, I want to filter a worksheet on the name of a supplier(column C) and on todays date (Column T) and then email them columns C:T from that filtered information could anyone help?
What I a after if possible please is a formula where it can work out how much money is left that month.
I would like to enter an "income" (that is variable) figure in a cell and in a return cell get how much of that is left depending on today's date with any upcoming bills for that month...
Can I have some help please on this
I want to include in the formula below
[IF TODAY() > TODAY () Leave blank
[Range("C23:P34").FormulaR1C1 = "=SUMIFS(Sales!C9,Sales!C5,R21C,Sales!C16,R22C,Sales!C21,R4C3,Sales!C24,RC2)"
Is this possible please
I am working on a staffing sheet. I have a list of dates in weekly increments going across row 2 (starting at M2 and going on to ZZ2).
And I need a way to retrieve the number in row 54 that corresponds with todays date. The tricky part (to me) is that todays date isn't going to...
I'm not sure if this can be done, anyone have any ideas?
I want a user to be able to only enter a time in a specific cell
I wish Excel to display this as hh:mm
I would like Excel to store this value as todays date, so if I change to "dd-mm-yy hh:mm", or measure against this value, it's not...
I am trying to add conditional formatting using end of month.
What I am hoping to have is this:
Enter a date in "A1"
Next "A2" has formula "=EOMONTH(A1,36)"
I would like to have three conditional formats showing
"Green" if today's date is in the preceding calendar month or earlier than "A2"...
I have some data with dates, I need to get notification for all work which are having near by today's date by excel vba
if today's date = date then those data will be popup on screen
this is my main file having these data
Okay, I'm running a macro and part of the macro says this:
tCell = Now
tCell.NumberFormat = "mmm d, yyyy hh:mm"
I like this because of the date and time stamp. Now that I've entered this macro, it has messed up my conditional format which colored the row if the cell matched today's date. Now...
I have had such success on this Forum that I will cheekily test your generosity once again!
Each day I import several hundred rows of data in columns A:K of a xlsm workbook interspersed randomly with blank rows and I must manually put today's Date into Column O:O of each row containing data...
I have spent several hours searching the internet for a solution to no avail.
I have an external reference (Daily Exchange Rate) that updates daily. I have a column with a daily date in each row for the entire year. I wish to make the cell next to "today's" date in that column reflect today's...