Calculate date and format without showing both number and date
Closed
rlw5009
Posts
2
Registration date
Wednesday 29 January 2014
Status
Member
Last seen
29 January 2014
-
29 Jan 2014 à 10:28
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 30 Jan 2014 à 20:40
Mazzaropi Posts 1985 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 - 30 Jan 2014 à 20:40
Related:
- Calculate date and format without showing both number and date
- Excel date format dd.mm.yyyy - Guide
- Date calculator app for windows - Download - Calculators
- Kingston format utility - Download - Storage
- Dvi format - Guide
- Swissknife format - Download - Storage
3 responses
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
29 Jan 2014 à 11:20
29 Jan 2014 à 11:20
rlw5009, Good afternoon.
Try this one!
=" HOURS WE "&IF($F$2="","",TEXT($F$2-7;" MM/DD/YY"))
Is this what you want?
Please, tell us if it worked for you.
I hope it helps.
Try this one!
=" HOURS WE "&IF($F$2="","",TEXT($F$2-7;" MM/DD/YY"))
Is this what you want?
Please, tell us if it worked for you.
I hope it helps.
rlw5009
Posts
2
Registration date
Wednesday 29 January 2014
Status
Member
Last seen
29 January 2014
29 Jan 2014 à 13:41
29 Jan 2014 à 13:41
Hmm. Excel is saying the formula contains an error.. I am using Excel 2010
Mazzaropi
Posts
1985
Registration date
Monday 16 August 2010
Status
Contributor
Last seen
24 May 2023
147
30 Jan 2014 à 20:40
30 Jan 2014 à 20:40
rlw5009, Good evening.
Opsss............ TYPO
Before: =" HOURS WE "&IF($F$2="","",TEXT($F$2-7 ; " MM/DD/YY"))
Now...: =" HOURS WE "&IF($F$2="","",TEXT($F$2-7 , " MM/DD/YY"))
Change semi-colon to comma at TEXT function.
I hope it helps.
Opsss............ TYPO
Before: =" HOURS WE "&IF($F$2="","",TEXT($F$2-7 ; " MM/DD/YY"))
Now...: =" HOURS WE "&IF($F$2="","",TEXT($F$2-7 , " MM/DD/YY"))
Change semi-colon to comma at TEXT function.
I hope it helps.
