Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Date Calcualation
- Thread starter CNeeds
- Start date
SkipVought
Programmer
If you have REAL DATES...
[tt]
=A1-TODAY()
[/tt]
Why do Dates and Times seem to be so much trouble? faq68-5827
Skip,
![[glasses]](/data/assets/smilies/glasses.gif "[glasses] [glasses]")
[red]Be Advised![/red] A Last Will and Testament is...A Dead Giveaway!
![[tongue]](/data/assets/smilies/tongue.gif "[tongue] [tongue]")
AnotherHiggins
Technical User
In A2:
=A1-today()
Format the cell as general or number.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
=A1-today()
Format the cell as general or number.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
SkipVought
Programmer
The LATE John...
RIP
Skip,
[red]Be Advised![/red] A Last Will and Testament is...A Dead Giveaway!
AnotherHiggins
Technical User
Darn you and your nimble fingers, Skip!
![[wink]](/data/assets/smilies/wink.gif "[wink] [wink]")
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]
Help us help you. Please read FAQ181-2886 before posting.
- Status
Similar threads
- Locked
- Question
- Locked
- Question