I have a start date and an end date in my sheet, in another column I have used the NETWORKDAY function to return the difference excluding weekends and holidays. is there a way I can get this number to be displayed as weeks and days, in seperate columns if need be.
I did consider /5 and returning the result with 1 decimal place to a work cell that would not be displayed. Then creating 2 new columns 'days' and 'weeks' so if the the result in the work cell was 6.2 say that would equate to 6weeks 1day.
In the days column I would then use something like =if(workcell=*.2,"1",if(workcell=*.4,"2", and so on (the syntax is probably incorrect here)
and in the weeks column I would return the number rounded down to the whole number giving me the number of week.
Is there a better way?
EDIT:the * is for anynumber as I thought it was used as a wild card. maybe not!
Bookmarks