Blanchetdb
Board Regular
- Joined
- Jul 31, 2018
- Messages
- 161
- Office Version
- 2016
- Platform
- Windows
Hi
I am using an English system...
My workbook has a number of worksheets, English and French. I am able to calculate the difference between two dates in the English worksheets as the date is entered in an English format (April 1, 2022)....
the formula used is =D15-AH4 which is April 1, 2022 minus January 1, 2021.
The D15 cell is in a Text format which is needed as it copies to a Word document using another macro I have within my workbook
This process works
My French worksheets requires the person to enter the date in a French format (1 janvier, 2022) as Text in cell D15
the formula is the same and the cells are both formatted as "Date / 1 janvier, 2022 - French(Canada)"
the issue is that I get a #Value error due to the dates being written in French
I tested the cells by inserting the English format and it works but as soon as the date is entered in French using the month format
is there a way around that?
thanks
I am using an English system...
My workbook has a number of worksheets, English and French. I am able to calculate the difference between two dates in the English worksheets as the date is entered in an English format (April 1, 2022)....
the formula used is =D15-AH4 which is April 1, 2022 minus January 1, 2021.
The D15 cell is in a Text format which is needed as it copies to a Word document using another macro I have within my workbook
This process works
My French worksheets requires the person to enter the date in a French format (1 janvier, 2022) as Text in cell D15
the formula is the same and the cells are both formatted as "Date / 1 janvier, 2022 - French(Canada)"
the issue is that I get a #Value error due to the dates being written in French
I tested the cells by inserting the English format and it works but as soon as the date is entered in French using the month format
is there a way around that?
thanks