Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date calculation
I have a worksheet with employees. Some new some old. A new hire is
considered to have been employed for a period of 6 months. I would like a formula that takes the current date, the hire date and calculates if the current date is 180 day greater than the hire date. If it is true I would like a cell to contain a blank or if it is false I would like the cell to contain the letter N. I created =IF(TODAY()(DATE(2005/05/01)+180)," ","N"). By its part they work but as a whole I have problems. Can some one please help. |
#2
|
|||
|
|||
|
#3
|
|||
|
|||
try:
=IF(TODAY()-180hire date,"","N") "USCBrad" wrote: I have a worksheet with employees. Some new some old. A new hire is considered to have been employed for a period of 6 months. I would like a formula that takes the current date, the hire date and calculates if the current date is 180 day greater than the hire date. If it is true I would like a cell to contain a blank or if it is false I would like the cell to contain the letter N. I created =IF(TODAY()(DATE(2005/05/01)+180)," ","N"). By its part they work but as a whole I have problems. Can some one please help. |
#4
|
|||
|
|||
Thanks Duke that was perfect. Appreciate it.
"Duke Carey" wrote: try: =IF(TODAY()-180hire date,"","N") "USCBrad" wrote: I have a worksheet with employees. Some new some old. A new hire is considered to have been employed for a period of 6 months. I would like a formula that takes the current date, the hire date and calculates if the current date is 180 day greater than the hire date. If it is true I would like a cell to contain a blank or if it is false I would like the cell to contain the letter N. I created =IF(TODAY()(DATE(2005/05/01)+180)," ","N"). By its part they work but as a whole I have problems. Can some one please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date calculation issues | Excel Discussion (Misc queries) | |||
date calculation issues | Excel Worksheet Functions | |||
Quick date calculation functions | Excel Worksheet Functions | |||
date calculation | Excel Worksheet Functions | |||
Date Calculation | Excel Worksheet Functions |