excel dates

I have three cells that display the number of days from a specific date 30 days(J26)-60 days (J27)-90 days (J28). A fourth cell with a vendor name In cell I2. I have figured out how to send an email in outlook from excel but what I would like to do is be able to have those dates show up in my...

Hi, I am struggling a bit to get my date formulas working. In a sense it is a 2 pt question. I basically have a date of which I need to add X amount of days which may go into into the next month at times. Then if that target date after getting added x days is a weekend or holiday it needs to go...

Hi I hope you can help me. I have a sheet that contains 3 columns, Label, Chip and Date, the label column can contain duplicate data if this occurs i need copy this date in the next row that contains the same label. Example: Label Chip Date 133 9871452 09/05/17 133 8971453...

I am trying to take a list of dates (specifically birthdays, anniversaries, etc.), and import them into my Outlook Calendar. I have seen a couple of articles and YouTube videos on this, but I can't get it to work. Using 2010 on both. Does anyone have a sure fire way to do this?

I have a spreedsheet which tracks a teams performance. There are multiple entries for TEAM each with different date, number, subject AS SEEN BELOW A1 B1 B2 B3 TEAM DATE NUMBER SUBJECT MM03 01/20/14 1620744 DROP MIM01...

Hi, I am a vivid reader of this forum. I am struggling with the below scenario. Your help is gonna save lot of manual work. Thanks in advance. Below are two sheets in my excel. Sheet1 Col1(obj) Col2 (Trade Date) ob1 2014-20-01 ob1 2014-21-01 ob1...

Hey all, So my situation is that we have an excel layout that has a column H that has dates that the item needs to be calibrated. I was wondering would it be possible to set an IF statement that would change either the box that has the date or a separate box to the side, either red for if it...

I have a query that pulls data from my database. The basic query looks like this: SELECT ClosedDate, ServiceRequestID FROM MyDatabaseNameHere Now SQL runs this and all my dates are in the basic format. (YYYY-MM-DD MM:SS:nnn) :( Since this is not user friendly I modify my query with Convert...