Date issues.

[spinkung]

Happy new year all,

I am trying to get a function to return a date based on the string in the preceding cell. If the cell, say A1, has the string "Before 12:30", i want the cell B1 to put the date 5 days from now in the cell. If there is any other string entered then 6 days from now. I also need it to include the networkdays function.

Here's what i've got, messy i know but functions aren't my strong point. Also would i save file size if i did this in VBA??

Please Login or Register  to view this content.

Cheers,
Spinkung.

[oldchippy]

Does this work for you?

Please Login or Register  to view this content.

[spinkung]

Thanks old chippy, the code didn't work as i wanted but i have since cracked it with.....

Please Login or Register  to view this content.

cheers.
Spinkung

[oldchippy]

Well done - and thanks for the feedback

[daddylonglegs]

I'd do it this way

=WORKDAY(TODAY(),6-(C2="Before 12:30pm"))