Formula for a date

[ExcelConfussed]

Can anyone advice me on how get the current date to display in a field
when I open a excel template I created.

 

[BrianB]

Not sure what you mean by "Field".

Code :
Range("A1").Value = Format(Date, "dd/mm/yy")

or, a simple formula in a cell :-
=NOW() and format cell accordingly

 

[Frans Gerber]

Thanks for your help. I guess by field I meant cell! The formulas you
gave me worked thanks. Can you also set it that the date will only
appear when you select that specific cell with the formula in it?

 

[Ron Rosenfeld]

Thanks for your help. I guess by field I meant cell! The formulas you
gave me worked thanks. Can you also set it that the date will only
appear when you select that specific cell with the formula in it?

You could try an event-triggered macro like:

======================
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Intersect(Target, [A5]) Is Nothing Then
Range("a5").Font.Color = Range("a5").Interior.Color
Else
Range("a5").Font.Color = vbBlack
End If
End Sub
======================

Assumes your formula is in A5.

To enter, right click on the worksheet tab and select View Code. Paste the
above code into the window that appears.


--ron

 

[Frans Gerber]

Great stuff thank you!