ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   SELECTING CURRENT DATE BY OPENING WORKBOOK (https://www.excelbanter.com/excel-programming/324480-selecting-current-date-opening-workbook.html)

R VAN DEURSEN

SELECTING CURRENT DATE BY OPENING WORKBOOK
 
I have a worksheet with the dates of a month, say 1jan,
2jan, 3jan etc. Is there a way that excel by opening the
workbook selects automaticely the current date.

Bob Phillips[_6_]

SELECTING CURRENT DATE BY OPENING WORKBOOK
 
see response in worksheetfunctions.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R VAN DEURSEN" wrote in message
...
I have a worksheet with the dates of a month, say 1jan,
2jan, 3jan etc. Is there a way that excel by opening the
workbook selects automaticely the current date.





All times are GMT +1. The time now is 10:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com