If several dates are entered a yes is entered
Closed
bbrewer88
Posts
1
Registration date
Wednesday 11 July 2018
Status
Member
Last seen
11 July 2018
-
11 Jul 2018 à 09:15
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 12 Jul 2018 à 11:28
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 12 Jul 2018 à 11:28
Related:
- If several dates are entered a yes is entered
- How to enter a - Guide
- Iphone 14 release dates - Home - IOS
- Vivatech 2024 dates - Guide
- Blackhat dates - Guide
- Enter is send in whatsapp - Guide
1 response
TrowaD
Posts
2921
Registration date
Sunday 12 September 2010
Status
Contributor
Last seen
27 December 2022
555
12 Jul 2018 à 11:28
12 Jul 2018 à 11:28
Hi Bbrewer88,
Not sure if that can be done without the use of VBA.
When Excel is open:
- Hit Alt+F11
- Click on 'Insert' on the top menu of the newly opened window
- Select 'Module'
- Paste the code below in the big white field
- Visual Basic window can now be closed
Here is the code:
Now we have a new function we can use in X1:
=mDate(E1,G1,M1)
Best regards,
Trowa
Not sure if that can be done without the use of VBA.
When Excel is open:
- Hit Alt+F11
- Click on 'Insert' on the top menu of the newly opened window
- Select 'Module'
- Paste the code below in the big white field
- Visual Basic window can now be closed
Here is the code:
Function mDate(xCell, yCell, zCell As Range) As String
If IsDate(xCell) * IsDate(yCell) * IsDate(zCell) = True Then
mDate = "Yes"
Else
mDate = "No"
End If
End Function
Now we have a new function we can use in X1:
=mDate(E1,G1,M1)
Best regards,
Trowa
