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 TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Excel: Find # of days employed
- Thread starter krets
- Start date
AnotherHiggins
Technical User
Like
=today()-A1
?
Format the cell containing the formula as General.
[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.
=today()-A1
?
Format the cell containing the formula as General.
[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.
- Thread starter
- #3
AnotherHiggins
Technical User
glad to help
[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.
Hi krets:
You could add the TEXT function to John's formula to get the result formatted as TEXT showing the number of days ...
Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
You could add the TEXT function to John's formula to get the result formatted as TEXT showing the number of days ...
Code:
=TEXT(TODAY()-A1,"0")Yogi Anand, D.Eng, P.E.
Energy Efficient Building Network LLC
AnotherHiggins
Technical User
I generally prefer to keep my numbers stored as numbers.
Zip codes, phone numbers, ID numbers, etc. are different because there's no reason to ever do any math with them. But the number of days employed? What if you want an average or something?
krets: IMHO, you should properly format the cell and store the data as a 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.
Zip codes, phone numbers, ID numbers, etc. are different because there's no reason to ever do any math with them. But the number of days employed? What if you want an average or something?
krets: IMHO, you should properly format the cell and store the data as a 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.
- Status
Similar threads
- Locked
- Question