If Date Function

  • Thread starter Thread starter Rose
  • Start date Start date
R

Rose

I would like to add the dates that someone is employed which is easy if you
have a Job Start Date and Job End Date. I just go something like C1-B1 and
format the calculating cell into a number. However, what do I want to tell
it if End Date is blank, calculate it by todays date?


Job Start Date Job End Date Days Employed
4/1/2009 7/1/2009 91
4/5/2009 -39908
 
I think you will need to test for A1 being blank (as Biff's approach did),
otherwise today's date will be returned on all "empty" rows your formula is
copied down to.
 
try this
=IF(B2<>"",B2-A2,TODAY()-A3)

--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another
 
Thanks Rick. I assume job start date to be mandatory..


If this post helps click Yes
 
Back
Top