Forum Discussion

Copper Contributor

Jan 11, 2024

Value Error when calculating dates, IF Function & WORKDAY Function

Hi - I'm getting a value error returned when trying to calculate dates in a formula and am looking for help. I'm looking to calculate a series of procurement dates (shipping, manufacture etc.) which...

excel

Formulas and Functions

Chris_Mercer

Copper Contributor

Jan 11, 2024

Excelonlineadvisor

Hi File is here

https://1drv.ms/x/c/5b76311aac56837f/ESAs6Na0iHVIlNvCoJH3deUBNeZT8cnUphKZqHB3DcJgaA?e=BLDFaF

Thanks

Excelonlineadvisor

Iron Contributor

Jan 11, 2024

Pls check the formula at AO9

Current Formula = =IF(AH9="International",WORKDAY(AS9-AN9,Table3),WORKDAY(AS9,-AN9,Table4))

Correction :- Instead of WORKDAY(AS9-AN9,Table3) , it should be WORKDAY(AS9,AN9,Table3)

Chris_Mercer
Copper Contributor
Jan 13, 2024
Excelonlineadvisor
Hi Thanks for the help - yes that clears the value error when I amend the formula to WORKDAY(AS9,AN9,Table3)... but that adds the number of days to the previous date whereas I need to subtract the dates back from the previous i.e. AO12 subtracts 5 working days from AS12 date to return the earlier date.
Weirdly when I re-entered the original formula into the cells with the minus sign the value error cleared??

Appreciate your help