today()

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...

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 _...

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.

Hey, I'm attempting to construct a formula that will sum entries in a spreadsheet that are in the past. At the moment I've tried variations along the theme of: Sumif(a3:a300, "<=today()", b3:b300) Firstly, I don't understand why this doesn't work (I'm a pretty inexperienced...

I am trying to setup a conditional formatting formula in Excel 2013 that will trigger as true if the date entered in an applicable cell is after today. I can get it to work as an if statement in a cell (not using conditional formatting) defined as this: If(E7>TODAY(),"True","False") I tried...

Hi all ... My supervisor told me that we needed to add two columns to our sheets, one being [=TODAY()] and second [=TODAY()+30] and we need it formatted as yyyy/mm/dd hh:mm:ss We have to save our final files in CSV. Fine and dandy until ... you have to reopen the file for any reason. The...

This is the strangest thing I've seen excel do in a while, I've got a sheet that I want to know when it was last changed. So I added the code below to an existing On-Change program When this code is in the macro, whenever I enter a value and press [enter], rather than going to the cell it...

Hello, I am using Excel 2007 and have a set of review dates for a number of people. Each person must have their next review within 10-12 weeks. I'm trying to set a conditional format on the next review date with the following; * if less than 90 days - highlights green * if less than 40 days -...

Hello All, I am trying to create an auto updating schedule tool. I have a table that has Row1 with times 8am to 8pm and then columns have staff and then dates. I want to check a cell against todays date. If it equals the date then it will copy the contents of the cell. If thedate does not...

I have a report that uses three ranges of dates for gathering data. I was hoping to use TODAY() as part of a filter but when I try and use it, say, After or Equal to TODAY()-10, it shows no records. If I then put in After or Equal to 3/18/2013 (today's date), then I have records. Any help?

I have a stock book in which profit is calculated by a formula and dated as per the date. I want to calculate today's profit. how can i do it. Thanks in advance https://picasaweb.google.com/117018858754008764470/MrExcel#slideshow/5845473510436117570

I need to add a formula which determines if the following (in column J): If F2 is empty, colour J2 cell red. If date in J2 is earlier than the last day of this month, colour J2 red. If cell J2 is empty - colour J2 red. The formula would then be applied for the whole of column J

I have a report that I download once a week however could be using it for a few days each week. I recorded some conditional formating but used =today(). Is it possible to change it so it makes the condition based on the day it is ran (monday) so that it doesn't change when I reopen the now saved...

Hi Excel Gurus, May I ask for your help, please? I am currently using MS Excel 2007 and aiming to add a formula in a spreadsheet (I am not an VBA expert, I'd prefer to use formula instead of VBA coding but if there's no choice, I'd like to know it also). I need to get the earliest date...

I have an excel template that I have been working on for the longest. The basic idea is for a user to be able to copy and paste values into it and the conditional formatting would decide what color the cell is suppose to be and would also give a total number of occurrences. The template works...

I am using Excel 2003 and am using the today() function to calculate the "Days since our last event." I have a PowerPoint presentation that includes a link to the calculated cell. The PowerPoint is set to run continually and I am leaving the Excel file open. I'm finding that our "Days Since"...

I’m trying to use a formula to check the cell to the right, and if there’s any data in there, it fills the cell containing the formula with today’s date. Well I’d like it to fill it in with the date that the data was entered into the neighboring cell and then remain that date forever, but...

Hi All, I need some help with conditional formatting for dates. Heres my criteria for conditional formatting: 1. if date is within 60 days - green color shading 2. if date > 60 days from today but < 120 days - yellow color shading 3. if date > 120 days from today - red color shading seems...

Hi I am trying to create an IF formula that contains a TODAY() formula. this is the formula =IF(TODAY()>G5," OVERDUE ",IF(AD5="Yes"," No "," OVERDUE ")) I have a spreadsheet that I need to know if something is overdue. Cell G5 is a date that is 21 days after the received date. Cell AD5...