Why am I getting an error on this formula?
Why am I getting an error on this formula?
Can anyone tell me why I am getting an error on the formulas in cells H8 through W8? It is a simple formula =cell + 7...
- Attachments
-
- Playwith.pmdx
- (190.47 KiB) Downloaded 31 times
-
raitis.veksejs
- SoftMaker Team
- Posts: 194
- Joined: Fri Sep 15, 2017 1:29 am
Re: Why am I getting an error on this formula?
This issue occurs because the dates in F8 and G8 are considered text by the program rather than numeric date values.
To ensure PlanMaker recognizes dates correctly, enter the dates using the same format as your Windows system settings (you can check your taskbar, e.g., if it shows DD/MM/YYYY, MM-DD-YYYY or something else). Once PlanMaker identifies them as valid dates, it assigns them a hidden serial number, allowing them to be used in calculations.
To ensure PlanMaker recognizes dates correctly, enter the dates using the same format as your Windows system settings (you can check your taskbar, e.g., if it shows DD/MM/YYYY, MM-DD-YYYY or something else). Once PlanMaker identifies them as valid dates, it assigns them a hidden serial number, allowing them to be used in calculations.