Hi,
i have two fields with dates - one field A1 for date authorised (for a data request) and one field B1 for date actioned (data request)
i need a formula to populate in C1 the following:
if A1 is blank then C1 is 'not actioned'
if B1 is blank then C1 is 'not complete'
if both contain dates then C1 to calculate the number of working days between the dates eg. A1 10.08.09, B1 11.08.09...C1 = 1 working day
thanks!
Last edited by Newport Count; 08-11-2009 at 05:18 PM.
Try:
=IF(A1="","not actioned",IF(B1="","not complete",NETWORKDAYS(A1,B1)))
Where there is a will there are many ways.
If you are happy with the results, please add to the contributor's reputation by clicking the reputation icon (star icon) below left corner
Please also mark the thread as Solved once it is solved. Check the FAQ's to see how.
Thats great - thank you
but just realised that i have missed one part out!
if both fields are blank then i require field C1 to be blank!
thanks again
Try then:
=IF(SUM(A1:B1),IF(A1="","not actioned",IF(B1="","not complete",NETWORKDAYS(A1,B1))),"")
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks