Hi,
I don't know much about formulas in excel and need assistance with creating a formula that can be used in a Gantt Chart. I imagine it's a nested formula. Currently, I'm using the INT formula in F4 cell to find the difference in weeks between two dates; however, I want F4 to remain blank or "N/A" if column E4 is empty (without a date). Please see diagram below for reference.
Any assistance would be much appreciated.
Gantt Chart Example.JPG
Thank you,
Christina
=if(e4="","", int(e4-d4)/7))
Wayne
if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here
If you have a solution to your thread - Please mark your thread solved do the following: >
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
Hi Wayne,
Thanks for your assistance. It came in the nick of time. I'm about to present my draft in 15 mins. The formula is exactly what I was looking for.
Much appreciation!
Stay healthy and be well,
Christina
you are welcome
good luck with presentation
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks