Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Field
Is it possible to insert a date field into an Excel spreadsheet like you can
in Word? A date field that would update to the current date each time you opened the spreadsheet? Thanks! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Field
=TODAY()
-- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "karenbeth24" wrote in message ... Is it possible to insert a date field into an Excel spreadsheet like you can in Word? A date field that would update to the current date each time you opened the spreadsheet? Thanks! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Field
karenbeth24 wrote:
Is it possible to insert a date field into an Excel spreadsheet like you can in Word? A date field that would update to the current date each time you opened the spreadsheet? Thanks! Sure, use the formula =TODAY() Keep in mind, however, this will update each time you open the sheet. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date Field
Try
=Today() Mike "karenbeth24" wrote: Is it possible to insert a date field into an Excel spreadsheet like you can in Word? A date field that would update to the current date each time you opened the spreadsheet? Thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
New date based on one date field minus minutes in another field | Excel Discussion (Misc queries) | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
Converting a date field into a month-year only field | Excel Discussion (Misc queries) | |||
Changing a text field to a date field | New Users to Excel | |||
How to Join/concatenate a date field with a time field in Excel? | Excel Discussion (Misc queries) |