use formula to calculate a number then if > 7 then divide by 7 to have a result in weeks
I am comparing two dates and the result is the number of days apart, negative or positive.
My formula I am using is =F12-$E$5. What I need to know is if this result is greater than 7 days then divide by 7 so the result is in weeks vs days. What do I need to do and what code is needed. Also, the answer could be negative and would need to
still divide for the number of weeks.
Anwsers to the Problem use formula to calculate a number then if > 7 then divide by 7 to have a result in weeks
Code worked great.
Is there something I can add if it is diplaying weeks, like maybe a w after the number with a space before the w?
First off, I am going to ask you to mark Ashish Mathur's posting as the "Answer" also.
The reason is his formula is more easily modified to do what you are now asking for...
=IF(ABS(F12-$E$5)>7,(F12-$E$5)/7&" w",F12-$E$5&" d")
Now, in case all those decimal places are too many for your use, here is his formula modified to display only 3 decimal places for the "weeks" values...
=IF(ABS(F12-$E$5)>7,TEXT((F12-$E$5)/7,"0.000 \w"),F12-$E$5&" d")
where the number of zeroes after the decimal point (inside the TEXT function call) controls the number of decimal places being reported.
One thing you should be aware of with the output you just asked for...
the formulas return text values that, because
they are no longer numbers, cannot be used in any numerical calculations.
NOTE: Please mark the message or messages (yes, you can mark more than one) that answer your question as the "Answer" so that others will know your question has been resolved.
Windows Error Reporting - To Fix use formula to calculate a number then if > 7 then divide by 7 to have a result in weeks
- Go to Start button.
- Open Control Panel.
- Go to Windows Error Reporting.
- Click on System and Maintenance, then click Problem Reports and Solutions.
- Next, click Change Settings located on the left side panel of the Problem Reports and Solutions window.
- Select an option to configure how you want Windows to look for a solution to your problems. You may allow Windows to do it automatically or ask you every time to check if problem occurs.
- Next, click the Advanced settings link.
- Select Off to turn off Error Reporting.
Recommended Method to Fix the Problem: use formula to calculate a number then if > 7 then divide by 7 to have a result in weeks:
How to Fix use formula to calculate a number then if > 7 then divide by 7 to have a result in weeks with SmartPCFixer?
1. Download Error Fixer. Install it on your computer.
2. After the scan is done, you can see the errors and problems need to be fixed. Click Fix All.
3. The Fixing part is finished, the speed of your computer will be much higher than before and the errors have been removed.
Related: 1723 There is a problem with this Windows Installer package A DLL required After installing Windows Vista SP2 my computer turns off while not being in use When turned back on I am asked if I want to start my computer normally BSOD in Windows 8 DRIVER POWER STATE FAILURE due to ntoskrnl exe need help with deciphering minidump Bluetooth Driver Not Connected after Windows 8 1 Install Backup in Windows 7 When I try to backup to my Seagate 3 5 inch push button backup 250 GB 2 0 external hard drive Model ST3250 601U2RK my computer shuts down C Windows Installer wiped Can t get admin tools to work in Windows 7 except config sys Cannot open attachments in Windows Mail Cannot use learn moodle as earlier after the Windows Internet Explorer 9 upgrade Changing letter of Windows 7 system partition Application stop working while running them in Windows 7 Deep Freeze Instalado no Windows 7 um grande problema Dell with preinstalled 64 bit Windows 7 shuts down while booting Desktop Icons disappear when right clicking on desktop in Windows 7 Auto rotate has stopped working on Acer 1820PT running Windows 7 in tablet mode DJ Inkers will not work on Windows 7 Is there a way to make it work,Can I sign into two Windows 8 computers using the same microsoft account at the same time realtek drivers download Did Windows 7 backup my hard drive causing the used space to double in one week from 225 Gb to 450 Gb realtek audio drivers InPageCoFire Error Windows Vista Home Basic realtek hd audio driver Query related to availability of date and time of the replied email from the original email in Windows Mail realtek drivers download Starting display problem Your computer did not shut down properly Windows is collecting information realtek driver Windows 7 logon error realtek driver Windows Update repeatedly offered realtek ac97 audio driver three Access the BIOS via either the F1, F2, Del critical, F10 or F11. To locate out which essential it is, watch the screen whilst your pc is booting to check out what keystroke will get you into the BIOS. Look into the Standard information and facts tab to discover the motherboard’s model and BIOS revision.
Read More: How to Fix Error - windows 7 themes:i have just made my first windows 7 theme which i want to share, how can i upload it or send it to you so you can use it??,[Solution] lost bluetooth, webcam, and possibly other items,How to Fix Problem - Keep Getting Error Message That IE has stopped Working?,Tech Support: Internet Explorer can't open this page - how can I resolve this problem and open the page?,[Solved] URGENT: Windows 7 Defragment Increases my Used Space and eats up my free space,Hyperlink issues and changes,Windows 7 fault that prevents reinstallation of software,Remote access using Windows 8.1,Can’t browse specific webpages when using Internet Explorer 8,clearing adobe flash player