I would like to know what formula to use to get the column for DAYS UNFILLED to automatically go up each day for the CRAFT. For example, the COOK for GREEN FROG has been open for 10 days as of 7/2/2015. How would I make it change to 11 for 7/3/2015. I would like for the person to put the date that the UNFILLED happen and it calculates based on today's date.
Keith C. AikenExample for OPEN CRAFT Report.xlsx
Last edited by coffaro; 07-02-2015 at 09:09 AM. Reason: Added Chart
It might be easier if you had a "start" date for each item.
1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.
Tom
Insert a column for the Start Date (column D for this example) then in the Days Unfilled column F for this example, enter in F7.
Formula:
Please Login or Register to view this content.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Newdoverman,
Not the OP, but....
Maybe I'm doing something wrong, but when I tried using Today(),(to help OP out) it would return a very odd date, like 1/10/1900. It's probably because I am doing something wrong.
My thought was to add a start date column (as you suggested) like column A then use....
But, as I am a novice, this might be the wrong approach...your thoughts?
Please Login or Register to view this content.
Format as GENERAL and the date will become a number.
Yea, I just noticed it was formatted as Date instead of general, my bad. Rookie mistake. Thank you
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks