in b1,d1,f1 and h1 I have a mane in the cell, is there a way that when I open the worksheet, sheet3, that the name stays in the cell and then todays date
will end up to the right of it in the same cell?
thanks
Keith
in b1,d1,f1 and h1 I have a mane in the cell, is there a way that when I open the worksheet, sheet3, that the name stays in the cell and then todays date
will end up to the right of it in the same cell?
thanks
Keith
Try:
=Sheet1!B1&" "&TEXT(DATE(YEAR(TODAY()),MONTH(TODAY()),DAY(TODAY())),"mmm-dd-yyyy")
If I've helped U pls click on d *Add Reputation
where do I put that formula?, i'm still new to excel, when I right click the sheet and pick view code then paste it there it all turns red
thanks
Keith
In sheet3 B1
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks