today

Hope someone can help – I have been struggling with this for ages! I have a formula with a multiple IF/AND statement incorporating dates and I just can’t get it to work. The conditions are as follows – A1 must be greater than 0, A2 must have YES entered, A3 contains a date which must be within...

I have date in my F1 like 12/03/2019 dd/mm/yyyy. I want formula in H1 that how much days remaining from currant date of today. Today is 08/03/2019, so answer in H1 should be "4". and tomorrow this H1 should be "3", automatic by formula

I'm looking to use a macro and not a formula to do delete old invoices automatically. please help if today is greater than 2/1/2019 then delete column A

Hi! I am trying to use an IIF to determine the day of the week. And then it should return different dates. Here is my problem: If today is Monday, return Monday - Friday of last week. If today is not Monday, return Monday - Now of this week. Below is the code I have tried using: IIF (...

Hi Everyone! So I have an Excel doc that I print out for a hand written report. I have a week beginning cell that should always show the upcoming Monday date, UNLESS today is Monday, then it should show today's date. I usually print this out on Friday, but last week did not have time to get it...

I use Excel for Office 365 in Windows 10. I have a spreadsheet called C:/Desktop/tkxl_f.xlsm which can have from two to twenty five sheets each with different and variable names and always located between a sheet called Blank and a sheet called Cover. I wish to copy and paste the range A1:K133...

Hi all, I would like to use a vba code so that to stop run in certain days. e.g.in 60 days from today. I prefer the days in Latin numeric. Therefore that is bit like licence expired. Thank you all in advance

I need a macro code which I can attach to a command button which will expand specific rows based on cell values. My sheet has a series of questions. or each question, there are 4 possible answers in a drop down menu in column A. If the answer has more than 4 characters in length, I need the...

Hey guys! I have in Excel/ Power Query a regular date column (DD.MM.YYYY). I would like to filter this column for year 2018 in total and 2019 to date. So for today 01.01.2018-05.02.2019. Is there any function for this? How can I manage this? best regards

February 1 has an Excel serial number of 43497. (fairly easy to figure out) Made a simple calendar based using the day function. =day(43497). Just copied it as necessary using the previous day +1 All is fine. Trying to use Conditional Formatting for today. It works, but when I apply it to...

Hello, I have values in column A and dates in column B. How can I count the new entries today? What I mean is count the ones that occur today that haven't been entered before. Thank you for your help, XJ

Hello: I need a formula to get a number of days from two fields: today date minus AssignedDate. I added an unbound field and wrote on control source: =today() - [AssignedDate] The above does not work and MS Access does not know what is Today(). Is there any other way to write the code so that...

I would like to compare a date to today to display the following where the date is in cell A1 If A1=Today then "Due Today" If A1 Greater than Today then "Overdue" If A1 Less than Today then "Due in x Days"(where x is the number of days until the date in A1) Any ideas Ian

Hello - I've searched the forum, but not found anything that specifically addresses my issue. I have a task list workbook that contains 4 sheets: Master, Today, Assigned and Done. All tasks are entered in Master, and I want to have the row deleted from Master and moved to the next available...

Is there a formula for determining if a Date & Time is TODAY? For example: <tbody> TIME TODAY 12/13/2018 4:02 AM 1 12/12/2018 8:31 PM 0 12/15/2018 1:02 PM 0 12/13/2018 5:17 PM 1 </tbody> Please note the 'TODAY' column. I'm looking for a logic formula that can tell me if it's today...

Hi i have a wee array formula here to show me last booking {=MAX(IF('[calendar.xlsx]full year'!$D$8:$ABG$103=B2,'[calendar.xlsx]full year'!$D$4:$ABG$4,""))} '[calendar.xlsx]full year'!$D$8:$ABG$103 - is where you book names B2 - client name to look for '[calendar.xlsx]full year'!$D$4:$ABG$4 -...

I have tried =SUMIF(A6,"<"&TODAY(),(C6:D6)) there is a 1 in both C6 and D6 and the date in A6 is 4 days ago so the result should be 2. I don't know why it is not summing it up. Also that is not my main objective what I want is for C5 and D6 to be added if the date is in the past but I was trying...

Hi guys, Me again! Trying to conditional format the whole sheet so that whatever date falls past today, then it will red out, however it conditions all blanks files to do this also, so everything in the file gets filled in :( Would appreciate the help! Thanks Will

Hello, I'm looking for a way to convert the YES input to the today date for example A3 is filled with Yes on Sheet1 sheet2 A4 should be filled with the Date of today. Is there a way to do this? If yes could you help me on the way? Thanks in advance Rgds, John

Hi, I have a cell A1 this contains a formula to pull a date from another worksheet using an Index and Match Formula In Cell A2 I want to perform a check to see if that date is greater than or less than today. The problem I have is that my formula in Cell A2 is seeing the formula in A1 and...