LinkBack URL
About LinkBacks
im trying to find a network days count between 2 dates. but i also need it to calculate only if there is a date in the cell. so if one of the cells is blank it will display a blank
im trying to find a network days count between 2 dates. but i also need it to calculate only if there is a date in the cell. so if one of the cells is blank it will display a blank
A1 Cell
28/01/2014
B1 Cell
28/02/2014
In C1 Cell
=IF(COUNTA(A1:B1)=2,IFERROR(NETWORKDAYS(A1,B1),""),"")
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
this is still not working
if a1 or b1 is blank then i need cell c1 to show blank. if both have a date then c1 to show the days taken between a1 and b1
Try using COUNT instead
=IF(COUNT(A1,B1)=2,NETWORKDAYS(A1,B1),"")
Audere est facere
Not sure where to post this, but here is a question regarding holidays.
when a person starts 06/22/2007 and after (1 year they get 10 days holiday) and (after 5 years they get 15 days) and (after 10 years they get 20 days) and (after 20 years they get 25 days holidays). I would like to have a cell automatically change from 10 days to 15 days automatically when the say 5th year anniversary is reached. Ive tried a few ways but cannot seem to be able to get past the first year anniversary.Here is what i have.
=IF(B5<=DATEVALUE("06/22/2007"),"10",IF(B5<=DATEVALUE("06,22/2011"),"15",IF(B5<=DATEVALUE("06/22/2016"),"20",IF(B5<=DATEVALUE("06/22/2026"),"25"))))
B5= today()
Start Date=06/22/2006
Am i anywhere near my goal?
Last edited by Vdogeek; 02-28-2014 at 10:40 AM.
Thanks anyways, I managed to find exactly what I needed here by doing a bit of searching and reading. Thanks anyways.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks