ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Formula (https://www.excelbanter.com/excel-discussion-misc-queries/178421-formula.html)

Phxlatinoboi®

Formula
 
I need to have a cell on excel automatically calculate if someone was hired
today, what day will they have completed their 90 days with a company.

David Biddulph[_2_]

Formula
 
=today()+90
--
David Biddulph

"Phxlatinoboi®" wrote in message
...
I need to have a cell on excel automatically calculate if someone was hired
today, what day will they have completed their 90 days with a company.




Roger Govier[_3_]

Formula
 
Hi

With hire date in A1
=A1+90
Format with whatever Date format you prefer

--
Regards
Roger Govier

"Phxlatinoboi®" wrote in message
...
I need to have a cell on excel automatically calculate if someone was
hired
today, what day will they have completed their 90 days with a company.



Max

Formula
 
"Phxlatinoboi®" wrote:
I need to have a cell on excel automatically calculate if someone was hired
today, what day will they have completed their 90 days with a company.


Assuming hire dates (real dates) are in A2 down
In B2: =IF(A2="","",A2+90)
Copy B2 down
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---


All times are GMT +1. The time now is 08:50 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com