Network days
Solved/Closed
Related:
- Network days
- Network card - Guide
- Wifi network - Guide
- Wireless network watcher - Download - Other
- Skype last seen days ago - Guide
- Network architecture - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
11 Feb 2010 à 12:25
11 Feb 2010 à 12:25
Well how about create a user defined function and use CDATE to return the date that you can use as you would like
1. Press ALT + F11
2. Click on Insert and choose Module
3. Paste
Public Function showDate(inDate As String) As Date
'if is a date, return value as month / day / year
If IsDate(inDate) Then showDate = Format(CDate(inDate), "mm/dd/yyyy")
End Function
Then you can use this function on you sheet. Lets say your date is in cell A1, then in B1 you can type
=showDate(a1)
you can format cell to what ever way you want.
1. Press ALT + F11
2. Click on Insert and choose Module
3. Paste
Public Function showDate(inDate As String) As Date
'if is a date, return value as month / day / year
If IsDate(inDate) Then showDate = Format(CDate(inDate), "mm/dd/yyyy")
End Function
Then you can use this function on you sheet. Lets say your date is in cell A1, then in B1 you can type
=showDate(a1)
you can format cell to what ever way you want.
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
11 Feb 2010 à 12:47
11 Feb 2010 à 12:47
You did type this line too right ?
Public Function showDate(inDate As String) As Date
If it still does not work, put your file at https://authentification.site
Public Function showDate(inDate As String) As Date
If it still does not work, put your file at https://authentification.site
rizvisa1
Posts
4478
Registration date
Thursday 28 January 2010
Status
Contributor
Last seen
5 May 2022
766
11 Feb 2010 à 12:56
11 Feb 2010 à 12:56
Ah well it is coz of regional issues. Change this ""mm/dd/yyyy" to dd/mm/yyyy
11 Feb 2010 à 12:42
sadly, it sis not working It simply return me back to the visual basic sheet and highlights the error in (inDate).
Just to confirm i typed in the below within the VB;
'if is a date, return value as month / day / year
If IsDate(inDate) Then showDate = Format(CDate(inDate), "mm/dd/yyyy")
End Function.
The below is is a shot of what i see in my spreadie;
LastAuditDateTime
Feb 5 2010 6:42PM
Feb 5 2010 6:41PM
Feb 4 2010 3:47PM
Feb 4 2010 1:33PM
Feb 5 2010 6:44PM
Aug 7 2009 5:57PM
Feb 8 2010 6:26PM
Feb 5 2010 2:36PM
Dec 23 2009 1:51PM
Jan 22 2010 1:27PM
Feb 5 2010 2:35PM
Feb 4 2010 3:47PM
Feb 4 2010 3:46PM
Feb 4 2010 3:47PM
Oct 27 2006 6:02PM
This info is all in once cell and i just need to run a network days formula of this, put it wont recognise the time etc which is causing the problem and im unsure how to reformat the cells to a recognisable format??
11 Feb 2010 à 12:46
Feb 5 2010 6:42PM
for the above i get 02-May-10??? not sure why??? any ideas, please?
help MUCH appreciated.