Text and date in code

tony_d

Board Regular
Joined
Sep 27, 2003
Messages
229
Is there any way to put into code the following as text in G2

"Due on" =todays date + 'G3'

In G3 there is a lookup giving a number this example is 30

So it reads "Due on 20/10/06

Today plus 30
 

Some videos you may like

Excel Facts

Did you know Excel offers Filter by Selection?
Add the AutoFilter icon to the Quick Access Toolbar. Select a cell containing Apple, click AutoFilter, and you will get all rows with Apple

Watch MrExcel Video

Forum statistics

Threads
1,114,059
Messages
5,545,758
Members
410,704
Latest member
Cobber2008
Top