today fuction

I have searched the forum and despite similar questions with similar VBA solutions all of them I have tried but none actually worked. I have a line of dates in a Leave sheet from cell b3 to ni3 which I wish to hide automatically. I would prefer not to have a cell with todays data in, but...

Hi, I am a novice and am looking for a formula to do the following: 1. If due date has not arrived, show Not Due 2. If due date has arrived and is less than 30 days over, show Due 3. If due date has arrived and is 30 days or more over, show Overdue 4. If completion date has been entered into...

Okay, I am beginner/intermediate Excel user for work. Working with Excel 2010. I have a thought process in my head for what I want to happen, but cannot figure out how to execute it. I am tracking employee attendance over a 12 month rolling calendar. Here is my spreadsheet; Basically I have...

Hi, I'm trying to build out this excel file to keep track of my finances. I could use some help with several formulas revolving around the pay schedule of a year. Any help would be appreciated and I can try toying around. I have a hard-coded list of all the pay dates in a year, for a...

Hi all, I need help with a formula, I need it to pull in the last day of the year when it looks up to a certain string of text... e.g. if it says ABC Ltd or ABC LTD International i want it to pull in 12/31/2020 otherwise any other company name it will pull in today's date. i know there is an...

Great day, I'd like to ask for you kind assistance Will it be possible to count the VL that falls under the date today? if yes can you kindly help please thank you so much:confused: 18-Mar 19-Mar 20-Mar 21-Mar 22-Mar 23-Mar 24-Mar Schedule Region Monday...

Hi I'm helping colleagues to extract data from a big table of info entered by week. The problem is that I want the date to be true at that moment and not the next month menaning that for a specific month the data should be extracted and not changed after that. My formula compares the date in a...

Hi guys - I'm confident this is an easy fix but I can't seem to crack it. I'm looking to calculate the workdays since another particular date. I'm sure its NETWORKDAYS and TODAY but I'm struggling. The first date is column D and days since is column E and the table is currently 50 rows...

Hello! Please help me out if you can.... This is my formula: =IF((G9)="x",(TODAY())," ") It currently will add the date to the cell with this formula in it when i enter a X into cell G9 and and the formula cell will be blank with nothing in it. I access this file almost daily and i want to...

Hey guys, I know this is simple but... I want to have a separate cell that tells me what % is for the day. Again i know this is simple but for some reason I'm drawing blanks..... B C...

I need a macro code inserted into my workbook that will stop the Today() and now() functions from recalculating every time a change is made in the work book. Students will be typing in numbers in columns A and E. When their number is inserted in column A, the "name"(column B), "date"(column C)...

Good morning, I have searched through some threads and can't find an exact match for what I'm looking to do. I have the incomplete formula below (which obviously doesn't work) however I can't seem to fit the date function into this formula...

Folks, I am trying to change data in a cell every year. A2..............B2 45..............5/20/16 On 5/20/17 I want the data to go +5, but I want this to happen every year. so far this is what I've tried A2..........................................B2...........H2 =IF(TODAY()=B2, H2+5...

Hello, I'm fairly new to Excel and when I was last on here people were able to help me out with the formula i was working on, now I'm seeking further pity with conditional formatting please. The excel spreadsheet data is generated through a Microsoft query linked to another program so when...

Hello all, I am a total newbie in Excel but I love it and I usually am able to do simple things just by trying until I get it, but this time I am completely stumped as nothing I try works. I will explain why I want to do what I am asking, but if you are not interested feel free to jump to the...

Hello All, I am looking for a formula that would say if today equals Monday then subtract 2. Thanks!