Network days
Solved/Closed
Related:
- Network days
- Windows network commands - Guide
- Network error occurred - Guide
- Network card - Guide
- Skype last seen days ago - Guide
- Cannot ping computer on same network - Guide
3 responses
rizvisa1
Posts
4478
Registration date
Thursday January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 11, 2010 at 12:25 PM
Feb 11, 2010 at 12:25 PM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 11, 2010 at 12:47 PM
Feb 11, 2010 at 12:47 PM
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 January 28, 2010
Status
Contributor
Last seen
May 5, 2022
766
Feb 11, 2010 at 12:56 PM
Feb 11, 2010 at 12:56 PM
Ah well it is coz of regional issues. Change this ""mm/dd/yyyy" to dd/mm/yyyy
Feb 11, 2010 at 12:42 PM
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??
Feb 11, 2010 at 12:46 PM
Feb 5 2010 6:42PM
for the above i get 02-May-10??? not sure why??? any ideas, please?
help MUCH appreciated.