• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 214
  • Last Modified:

I need to update the following formula

I need to update the following formula to return the value it finds in 3/14/01 date format. Right now, its returning the hard number, 41492...

Notice that I am trying to add some text in the same cell.

=IF(Y10="","",WORKDAY(I10,-10-ROUND(Y10/IF(Y10<=1500,175,300),0)))&" (A)"
0
wrt1mea
Asked:
wrt1mea
  • 2
  • 2
1 Solution
 
Rob HensonIT & Database AssistantCommented:
Try this:

=IF(Y10="","",TEXT(WORKDAY(I10,-10-ROUND(Y10/IF(Y10<=1500,175,300),0))),"mm/dd/yy")&" (A)"

Change the section "mm/dd/yy" to format as required.

Thanks
Rob H
0
 
wrt1meaAuthor Commented:
Its saying there are too few arguments for this function...and is placin the cursor between the 2nd and 3rd cursor after ,300),0)))
0
 
Rob HensonIT & Database AssistantCommented:
I was just checking the brackets on my version that I just copied from the question as I may have got them wrong and I have also spotted something else.

Where Y10 is blank you will end up with the " (A)" section. Do you actually want this or should blank in Y10 result in blank result?

If so, with corrected brackets:

=IF(Y10="","",TEXT(WORKDAY(I10,-10-ROUND(Y10/IF(Y10<=1500,175,300),0)),"mm/dd/yy")&" (A)")

Thanks
Rob
0
 
wrt1meaAuthor Commented:
PERFECT! Thank you!
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now