hi everyone
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...
Hi all
I have a dropdown list to select a particular year - how can I add an =IF to check if this selected year is less than 5 years from the current date?
TIA
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:
(Example: D2...
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...
Hey,
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?
Thanks
Hi,
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...
Hello all
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
Hello,
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...
Hi,
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...
Hello if I use this macro it takes me to GP3
in cell A1 I have =TODAY(), how do I jump to the cell that has todays date in?
<code>Sub Jumpto()
Range("GP3").Select
End Sub</code>
Thank you Jason
Hi guys,
I was wondering if anybody could help me with a formula to find the next April from Today's date?
I've tried searching but I can't find a thing!
Thanks in advance
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"...
Hi
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
for example
if today's date = date then those data will be popup on screen
this is my main file having these data
<colgroup><col><col></colgroup><tbody>
Person
Date...
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...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.