Keyven
asked on
Comparing MMM-yyyy dates to dd-MMM-yyyy dates
I have a Excel VBA Workbook which currently uses the following Date Format:
dd-MMM-yyyy (eg. 01-Mar-2007)
but i need to convert it to: MMM-yyyy
However, comparisons still need to be made between MMM-yyyy and dates using the dd-MMM-yyyy format... do i need to explicit code it to have a Day?
Is there a pre-defined code to convert:
MMM-yyyy to automatically assume the LAST day of the month (eg. 31-Mar-2007, 28-Feb-2007, etc) when i need to compare to a dd-MMM-yyyy?
dd-MMM-yyyy (eg. 01-Mar-2007)
but i need to convert it to: MMM-yyyy
However, comparisons still need to be made between MMM-yyyy and dates using the dd-MMM-yyyy format... do i need to explicit code it to have a Day?
Is there a pre-defined code to convert:
MMM-yyyy to automatically assume the LAST day of the month (eg. 31-Mar-2007, 28-Feb-2007, etc) when i need to compare to a dd-MMM-yyyy?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.