Nov 01 2022 12:29 PM - edited Nov 01 2022 03:06 PM
Hello.
I am using a Custom Formula in Column B, C, G and H, to format how the date will show on an excel Gantt Chart. My aim is for Column B to calculate 5 days prior to what is in Column C (example: Cell B2 formula is: =C2-5). Here is the problem:
Is there a formula that I can write in the Column B cells that ignores the blank cells in Column C (which really aren't blank because there is a formula in them with a custom Date setting) and leaves the cells in Column B blank as well? Please find my sample of the sheet below.
Thanks so much!
Nov 01 2022 01:03 PM
Use this cell formatting code for your dates in C:
mmm dd yyyy;;;
Nov 01 2022 01:20 PM
Nov 01 2022 01:42 PM
That's odd. I'd have to see the sheet. You could try this one:
[<>0]mmm dd yyyy;[=0]""
Nov 01 2022 01:54 PM
Nov 01 2022 02:53 PM
Nov 01 2022 02:56 PM
Nov 01 2022 03:46 PM