Forum Discussion
Sunnymom1263
May 20, 2025Copper Contributor
Need help with a formula
Im building an employee data sheet and one of the columns is HIRE DATE, the next column is 90 DAY REVIEW DATE. Both columns are date formatted. The formula in the 90 DAY REVIEW DATE cells is simply the hire date + 90. The problem is that if there is not a date in the hire date cell, the date that is being displayed in the 90 DAY REVIEW DATE is 3/30/1900, (I assume this is the default beginning date in Excel?) I do not want anything displayed in the 90 DATE REVIEW DATE column is there is not a date in the HIRE DATE column. Can someone help me with this please?
try adding an IF to the formula:
=IF( [Hire_Date]="", "", [Hire_Date] + 90 )
3 Replies
Sort By
- Sunnymom1263Copper Contributor
Thanks!
- m_tarlerBronze Contributor
try adding an IF to the formula:
=IF( [Hire_Date]="", "", [Hire_Date] + 90 )
- BhatiaCopper Contributor
Sunnymom1263:
Is this what you are looking for: