NadoDude
Board Regular
- Joined
- Jun 24, 2010
- Messages
- 84
I am trying to use the following formula to display both the start date and end date in the same cell separated by a dash, my formula is: (all cell references are dates)
=IF($P2="",$O2+90,$P2+90)&" - "&IF($P2="",$O2+90,$P2+180)
The formula results are the dates, but displayed as numbers (38973 - 39063).
Is there a way to structure the formula to display as the dates? (9/12/2006 - 12/12/2006)
=IF($P2="",$O2+90,$P2+90)&" - "&IF($P2="",$O2+90,$P2+180)
The formula results are the dates, but displayed as numbers (38973 - 39063).
Is there a way to structure the formula to display as the dates? (9/12/2006 - 12/12/2006)