Help with WORKDAY formula

**Melbourne93** · 02-13-2015, 01:08 AM

Hi,
This is my first post so sorry if it's a struggle to understand.

I just have a question regarding the WORKDAY formula.

I'm trying to make an orders schedule for work and I was wondering if there is a way I can have 2 formulas in 1 cell but it only calculates to the cell that has been entered.

For example, I have 11 columns that are calculated from the 'Confirmation date' but some orders aren't required until certain dates, so I would like to add a column for 'Date required' and the 11 columns calculate from the 'Date Required' instead of the 'Confirmation Date'

as I said, i'm very sorry if it doesn't make any sense, but any help would be greatly appreciated.

Thanks

**FDibbins** · 02-13-2015, 01:47 AM

Hi, welcome to the forum

It makes perfect sense

THis is generic, adjust to suite, you would need something that goes along the lines of...

=IF(Date-Required=XX,your-formula,"")
where Date-required is gee, guess what, the date requited lol
and XX is your criteria date

If you want something else shown if the DR is not met, you can put text between the ""

If you still have a problem, upload a small (clean) sample workbook (not a pic) of what you are working with, and what your expected outcome would look like.

**Melbourne93** · 02-13-2015, 04:03 AM

Paint Schedule.xlsx

Thanks for your reply!

But I am still confused as to what i'm doing lol

the attachment shows one of the schedules I need to make, what I want to be able to do is write in confirmation date into all the orders and then in some of the orders be able to write in the Date Required column and it overides the calculation from date ordered.

Thanks again