what formula auto inputs a date week from now?

[soupi]

I have dates in column A and I want column B to show the date 7 days from now... Which formula would i use?

For example: column a is 7/14/2015... column B should auto generate 7/21/2015

thank you.

[berlan]

If A1 is a date, then B1 could be

=if(isnumber(A1),A1+7,"")

Or use VBA with a worksheet change event.

[FDibbins]

What you need to understand about dates and times in excel is...

a date is just a number representing the number of days passed since 1/1/900...and then formated in a way that we recognise as a date. So, for instance, today (Tue Jul 2015) is actually 42199

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

Once you understand that, it is easier to see that =yourdate+7 will give you a date that is 7 days from yourdate. You may need to format it ad date

[soupi]

this formula worked in the past =TEXT(IF(WORKDAY(Q2,5)<=R2,WORKDAY(Q2,5),R2),"mm/dd/yyyy")

but now but it seems that the way the data out puts from our system is in this format...

2015-12-01, so is there a formula I can create that will read that date.

I tried this =TEXT(IF(WORKDAY(J3,5)<=K3,WORKDAY(J3,5),K3),"yyyy-mm-dd") but that didn't work....

There are to many records, so I cannot go to each record and change the date format from 2015-12-01 to 12/01/2015, unless there is a easy way in excel

[FDibbins]

Try using Text2Columns...
highlight the range
data/T2C/next/next/check DATE and select your format/OK

Why are you converting you answer to text though? You wont (easily) be able to use that in any other calcs. If you just run the calc and format/date as needed, it should give you what you want