Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need date to appear 90 days later than initial date entered
I want to input a date into column a and have it appear 90 days later in
column b in order to track due dates, etc. |
#2
|
|||
|
|||
=A1+30 (format as dates)
************ Anne Troy www.OfficeArticles.com "Becky" wrote in message ... I want to input a date into column a and have it appear 90 days later in column b in order to track due dates, etc. |
#3
|
|||
|
|||
LOL. I think I said 30. I meant =A1+90
************ Anne Troy www.OfficeArticles.com "Becky" wrote in message ... I want to input a date into column a and have it appear 90 days later in column b in order to track due dates, etc. |
#4
|
|||
|
|||
=IF(A1+90=TODAY(),A1,"")
perhaps? -- HTH Bob Phillips "Becky" wrote in message ... I want to input a date into column a and have it appear 90 days later in column b in order to track due dates, etc. |
#5
|
|||
|
|||
Insert =A1 in B1 and fill down as necessary!
Select column B, Format/Conditional formatting, select Formula, enter in Condition =A1+90TODAY(), Click Format, in Font tab select Color and set it white! Regards, Stefi €˛Becky€¯ ezt Ć*rta: I want to input a date into column a and have it appear 90 days later in column b in order to track due dates, etc. |
#6
|
|||
|
|||
By the way, Becky. Perhaps you should consider just using conditional
formatting? You can set column A's date to have a red font or red fill when it's 90 days or older. :) ************ Anne Troy www.OfficeArticles.com "Becky" wrote in message ... I want to input a date into column a and have it appear 90 days later in column b in order to track due dates, etc. |
#7
|
|||
|
|||
Good afternoon Becky Lets assume that your first used cell in column A is A7. A date will be in A7, in B7 put this formula: =IF(NOW()-A790,A7,"") Cell B7 will remain empty until the date in A7 is 90 days old, and then the date will appear in B7. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=468202 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
How would I change a date cell to decrease it by business days? | Excel Discussion (Misc queries) | |||
How to change (delivery) days and automatically the receive date in an other cell? | Excel Worksheet Functions |