thursday

Hi I am Preethi, Please help me in VB Script I have large excel file which I have to mail the particular line items to customers. (for example) <colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Code...

I have a sheet with a date in Column B. I need to find the closest Thursday that is 150 days prior to this date. I can't seem to get the formula to make this happen. Any help would be appreciated.

Hello, I have searched for an answer but I am probably asking the wrong question. What I am looking to do is a create a cell that will start with a value of zero and every Thursday it adds a 2 to the number already there. I'm sure it's possible but I can't seem to find anything. I thank you in...

I apologize, I really got reamed for my last post (and justifiably so) and I will try to make it right this time as not to waste your time again. I would like to get the number of days between the last two dates in the date column that has the task columns checked (columns C, D, E & etc.)...

Hello, I am wondering how to enter the month and date on a new spread sheet that excludes sat and sun but adds tues and thur twice on the spead sheet. Can someone assst? It should look like this <colgroup><col></colgroup><tbody> Monday, June 3, 2019 Tuesday, June 4, 2019 Tuesday, June 4...

I am computing an end date for the weekly publication of an advertisement. The inputs are the start date and the number of total insertions, while which Thursdays to insert the ad is based on a binary pattern like 00101 which would mean the third and fifth Thursday of the month - every week is...

Hello everyone! I need to get a report from an Access file. The report must contain attendance days in a week that can be one or two. For example, Mr. A comes on Saturday and Thursday, and Mr. B comes on Monday and Thursday. I want the report to show me who comes when and how many people are...

Hi I have a 26 week daily sales data dump that I need to sum X week week to date I have my week number (1, 2.. 26) along row 1, split out by Sunday, Monday... Saturday in row 2 with sales data below Below is required output, how can I go about this? <tbody> 1 1 1 1 1 1 1 2 2 2 2 2 2 2 3 3...

I have been trying to get NETWORKDAYS formula to work but for some reason it just won't do it. I have resorted to using the below formula but it just doesn't seem to want to take into account the holidays. so the formula is: IF(WEEKDAY(A3,2)>5,"",NETWORKDAYS(A$2,A3,$R$3:$R$10)) A3 is the...

Hi, I have a data input sheet as follows: <!-- Please do not remove this header --> <!-- Table easily created from Excel with ASAP Utilities (https://www.asap-utilities.com) --> <table border="1" bordercolor="#C0C0C0" bordercolordark="#FFFFFF" cellpadding="0"> <tr><td bgcolor="#FFFFFF"...

HI all Using workday function to give me T-1 days. So for example if its Thursday, it will return Wednesday based on the function = Workday(Date, -1) Now Im trying to make this work so it excludes every friday. For example, if on Monday, i want it to return Thursday (not friday) Any help is...

Is there an excel formula that will calculate the week ending (Thursday) date for the specified data?

I need help pulling the first thursday from the year specified in a cell. Cell a2 contains a year that will change and I need cell C1 to always return the first thursday of the year in cell a2 and am new to excel and can't find a solution

I've looked at this until my eyes are crossed and I'm sure someone out there can easily figure this out. I need a formula to spread project time hours across weekdays to equal 8 hours/day and 40 hours/week. I'm looking for a formula to copy from C2:G10, please. <tbody> A B C D E F G 1...

Hi I have column like the one below. I want to highlight all cells that contain Friday. So I went to CF-->highlight cells rules-->text that contains, then i typed Friday (or later typed friday) but nothing happened. What could be the issue? I highlighted the column before applying CF. Also the...

Using excel 2016 I have dates in columns A and C and values in columns B and D. The datesand their corresponding values are not matched but I only want to compare the values in B and D with their correspoding dates. Is there a formula I can put in the adjacent columns to match the dates with one...

Hello Folks, I am preparing a daily, weekly and monthly report. For weekly report I need a weekdays order from Thursday to Wednesday. When I pull data for this week in the filter it should filter from Thursday to Wednesday. Please suggest an idea whether in vba or formula. Thank you.

Hi I am preparing the Project Plan and in which i need arrive at a day when task is suppose to happen. E.g BRD Completed - Mon,20,Aug,18 Submit BRD for BS-Review(cut off is every Friday or Tuesday) Review Date: Every Monday and Thursday I have used following formula H29 = Mon,20,Aug,18...

I am doing a personal budget and wanted I40 and I41 to add together if the 25th of the month fell on a Saturday. <tbody> H I J 40 Car $445 25 41 Groceries/Gas $150 Saturday </tbody> Below you can see on the 25th of the month (Saturday) the $445 took (I27) but not adding in the $150...

Hi all, I need to calculate how many Mondays, Tuesday's etc. an employee worked over a given time frame. It's not as simple as "tell me the # of Monday's between January and May.' See my condensed example using Thursday (i.e. how many Thursday's did this employee work between January and May...