Special today Date challenge question

Z

ZONNET

What I want is have a today function eg in cell A1.

based upon entering any text in for eg b2, puts me the julian dat in cell
A2, So far, so good, I got that working.

Here is the challenge, the next day, I will have a new today date, however
I want to keep the juliandate in cell A2 as the day of yesterday. At this
moment, this date is also changing to the new today date.

I know it is possible with copy and paste special-value to get away from the
formula in A2, but that is not what I want.
Who has the answer????

many thanks
Emile Paulussen, the Netherlands
 
D

Don Guillett

right click on the xl logo to the LEFT of FILE. Insert this.
Everytime you open the workbook it will put in today's date in cell a1 on
sheet 7.
Private Sub Workbook_Open()
Sheets("Sheet7").Range("a1") = Date
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Formatting Less Than Today Week Days only 0
Formatting a spreadsheet to calculate difference in dates etc. 2
Multiple Challenging Excel needs.... 0
Color a cell based on column date and row content 2
Date Conditional Formatting 4
Need to auto-enter last updated date, only if another cell has changed 1
Match/Index/Sum function with date range 2
Today() and IF Function 7

Top